Csv Import With Null Fields

[peterlaursen]

It is a 'strict mode' issue!

See:

http://www.webyog.com/faq/28_72_en.html

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

I cna reproduce this:

Code:

set sql_mode = 'STRICT_ALL_TABLES,NO_ZERO_IN_DATE';
load data infile 'c:\documents and settings\peter\skrivebord\test.csv' into table tablename1 FIELDS TERMINATED BY ',' ENCLOSED BY '”' LINES TERMINATED BY 'rn' (id,t,ts);

returns

Quote:

Error Code : 1292

Incorrect date value: '' for column 'ts' at row 2

(361 ms taken)

Either use latest SQLyog RC or issue the statement

Code:

set sql_mode = '';

manually

[ddaily]

Ok, set session sql_mode = ' ';

worked.

Thanks.

[Author]

Posts