hi friend you should read this,
The problem is that those empty values are interpeted as empty strings (''), not as NULL values.
To force a NULL value into those fields you can change your text-file and use the escape character "\N".
http://stackoverflow.com/questions/1704304/what-is-this-error-database-query-failed-data-truncated-for-column-column-na[
^]
http://dba.stackexchange.com/questions/4091/data-truncated-for-column[
^]
see this Example:
mysql> create table a (a float not null);
Query OK, 0 rows affected (0.11 sec)
mysql> insert a values ('');
Query OK, 1 row affected, 1 warning (0.05 sec)
mysql> show warnings;
+
| Level | Code | Message |
+
| Warning | 1265 | Data truncated for column 'a' at row 1 |
+
1 row in set (0.00 sec)
mysql> set sql_mode = 'STRICT_ALL_TABLES';
Query OK, 0 rows affected (0.02 sec)
mysql> insert a values ('');
ERROR 1265 (01000): Data truncated for column 'a' at row 1
regards
sarva