I've used the 'load data infile' command to import data from a file and it
worked well for my purposes. See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html for the full syntax.
Rhino
- Original Message -
From: "Manuel J. Contreras Maya" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
I managed to do it using
mysql> load data infile '/home/manuel/databases/import.txt'
-> into table countries
-> fields terminated by ';';
Query OK, 240 rows affected (0.01 sec)
Records: 240 Deleted: 0 Skipped: 0 Warnings: 18
(I will check the warnings...)
I guess my system do not have mysq
There's a tool called "mysqlimport". I recommend using that. Or, if you
have to extract data from a larger set, you could write a program. But,
mysqlimport is the easiest way. If you're on a UNIX machine, run 'man
mysqlimport' for more information.
Good luck,
Brian
-Original Message-
Fr
