Re: Importing data from a file
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: Monday, October 25, 2004 1:59 PM 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Importing data from a file
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]
RE: Importing data from a file
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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]