Import data to table through a script

[Anon]

file.
I have an ascii text file called "MyData.txt" which contains the following data:

1
2
3

I create a text script file naming it: "MyData.sql" that contains the follwing SQL commands:

CREATE DATABASE MyDb;
USE MyDb;
CREATE TABLE MyTable (MyField INT);
MySqlimport MyDb MyData.txt;

I run it by typing:

c:\mysql\bin\MySql < MyData.sql

And I get an error message saying:

ERROR 1064
You have an error in your SQL syntax near MySqlimport MyDb MyData at line 4

Can anyone tell me what "Error 1064" means ?
Where can i find errors list? I searched in the tutorial (www.mysql.com) and couldnt find.
Anyone has any idea whats wrong with the above script and command ?
Thanks a lot !

[Anon]

Hi,

MySqlimport IS NOT a SQL command, it IS a program. You must execute it from the shell.

Josemi

[Anon]

I understand that the only way to do it is:
C:\mysql\bin\mysqlimport MyDb.sql
and it cannot be entered to a script file.
Thanks !

[Anon]

That won't work either.

You need to create the tables AND THEN import the data.

you can do it by hand by typing...

mysql < MyDB.sql
mysqlimport MyDb data.txt

or just put those commands in a BAT file.

[Anon]

Very good instructions and ideas for a beginner like me !
So, thanks a lot again !!!