Page 1 of 1

MySql

Posted: Thu Aug 07, 2003 2:46 am
by dave_c00
Hi,

I have connection to a server and have created a database on that server. Now i wish to make a table in MySql and populate it with a text file of data. I know to make the table using CREATE but how do i feed the text file into it?? Can anyone help me with this??

Thanks

Dave

Posted: Thu Aug 07, 2003 9:34 am
by daven
LOAD DATA LOCAL INFILE "filepath/name" INTO TABLE tablename

Posted: Sat Aug 09, 2003 5:03 am
by tylerdurden
What kind of text file do you have? Tab delimited? Comma delimited? Or a dumpfile from another database. In any case have a look at http://www.phpmyadmin.net/ it will help you import files into MySQL (and with anything else concerning MySQL).

http://www.mysql.com/doc/en/Loading_tables.html is the official manual section.