mysqlmysqlimport

Mysqlimport and NULL values

I am trying to load some pipe-delimited text files into tables using mysqlimport / LOAD FROM INFILE.

The files uses empty delimiters || for NULL values.

The result is a huge amount of warnings

Warning 1366 - Incorrect integer value: '' for column

while importing.

I don't know if it's safe to ignore the warnings or not.

Doing a find-replace for || in the text file is kind of a last resort as their combined size is above 1GB. Any input?

Solution

  • Can your column be null or not in your DB schema ?

    If it can, it should be alright.