You could write a little script that loops through your lines in the csv
file, makes the changes to fields you need and insert into the database
then.
This gives you full control over the new table structure (order,types, etc)
Olaf
On 5/31/07 12:02 AM, David Scott [EMAIL PROTECTED] wrote:
First of all I am very much a newbie with MySQL.
I am trying to create some tables and then read in some data from a .csv
file using load data infile 'filename.csv'
The data in the .csv file has actually come from another database system.
I have two problems which I haven't been able to