Page 1 of 1

Working with a text file and MySql

Posted: Tue Aug 12, 2003 10:31 am
by dave_c00
Hi,

I need to be able to read a text file into a table i have created in MySql on a server. The text file is data from an access database table and is seperated with commas between each field.

Is there a simple piece of code that can do this,

Thanks

Dave

Posted: Tue Aug 12, 2003 1:18 pm
by JAM
Try http://www.mysql.com/doc/en/LOAD_DATA.html for some good explanations.

Personally, i use either phpMyAdmin or a GUI like MySQL-Front.