MySQL Solving data load problems? -

MySQL Solving data load problems? -

i have experienced several problems trying load info text or csv file, table in mysql workbench database.

first of all, scheme unable find text file path c:\test.txt.

from stackoverflow learned when using windows, either slash, /, og 2 double backslashes ,\\, should used instead. in cases can utilize /, in other cases can´t.

does know why?

as solved, other problem appeared occurring when trying load info table, file.

first of all, created table using script:

create table testtable ( entry_id int not null auto_increment primary key, title varchar(80), book_number int );

then made text file, test.txt, these contents :

1,first book,17 2,second book,34 3,third book,64 4,fourth book,69

and placed on c-drive.

finally tried load info text file table 'testtable', using script:

load info local infile 'c:\test.txt' table testtable;

the next error messages appeared :

18:10:05 load info local infile 'c:\\test.txt' table testtable 4 row(s) affected, 12 warning(s): 1265 info truncated column 'entry_id' @ row 1 1261 row 1 doesn't contain info columns 1261 row 1 doesn't contain info columns 1265 info truncated column 'entry_id' @ row 2 1261 row 2 doesn't contain info columns 1261 row 2 doesn't contain info columns 1265 info truncated column 'entry_id' @ row 3 1261 row 3 doesn't contain info columns 1261 row 3 doesn't contain info columns 1265 info truncated column 'entry_id' @ row 4 1261 row 4 doesn't contain info columns 1261 row 4 doesn't contain info columns records: 4 deleted: 0 skipped: 0 warnings: 12 0.031 sec

i have tried both txt , csv files, , in cases have received error messages wrong integer values.

can help?

thanks in advance.

i think first column autogenerated, primary key , autoincrement. seek not set first integer in csv file, set 2 columns per row on file.

mysql