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]