Import

How can I import data from a .txt file (delimited) to a mysql table??

Please note that the txt file contains data for a few columns only.


So if the mysql table contains 6 columns, the txt file contains data for 3 columns only.

Please help. Thanks.

Hi

Make sure you have a backup first of your existing date just incase.

Then

load data infile 'filename' into table tablename (field1, field2 field3);

and that should do it

Regards
Darren http://www.php4hosting.com/ $ http://www.php4hosting.co.uk/ £