Working with a text file and MySql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
dave_c00
Forum Commoner
Posts: 37
Joined: Wed May 28, 2003 6:08 am

Working with a text file and MySql

Post 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
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
Post Reply