Hello everyone,
I am very new to MySQL and just started to play arounnd with it.
I have created a table with 4 fields and I am trying to populate this table with data from a flat file. The flat file has exactly 4 fields and they are separated by commas.
I am using the load data command as follows -
load data
local infile 'acdata.txt' replace
into table ACLookUp
fields terminated by ','
(Field1, Field2, Field3, Field4);
The data is not going in right. Two records from the file are getting loaded as one record in the table and the data is all jumbled up.
Am I doing something wrong ? Please help.
Thanks in advance.
- Subha
Nothing is impossible, even the word impossible says I'm possible.
I am very new to MySQL and just started to play arounnd with it.
I have created a table with 4 fields and I am trying to populate this table with data from a flat file. The flat file has exactly 4 fields and they are separated by commas.
I am using the load data command as follows -
load data
local infile 'acdata.txt' replace
into table ACLookUp
fields terminated by ','
(Field1, Field2, Field3, Field4);
The data is not going in right. Two records from the file are getting loaded as one record in the table and the data is all jumbled up.
Am I doing something wrong ? Please help.
Thanks in advance.
- Subha
Nothing is impossible, even the word impossible says I'm possible.