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 mysqlimport,
[EMAIL PROTECTED] manuel]$ man mysqlimport No manual entry for mysqlimport
Thanks a lot!
Manuel
Brian Abbott wrote:
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-----
From: Manuel J. Contreras Maya [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 10:00 AM
To: [EMAIL PROTECTED]
Subject: Importing data from a file
Hello,
I am new in mysql and I woul like to ask what is the best way to import data from a file.
Cheers,
Manuel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
