[SOLVED] Note: #1265 Data truncated for column 'date' at row 1

[fantomel]

hello please can someone explain to me why does it gives this warning ?

 

 

Inserted rows: 1
Inserted row id: 1
Note: #1265 Data truncated for column 'date' at row 1
Note: #1265 Data truncated for column 'expire' at row 1

[PFMaBiSmAd]

You tried to put in data that was longer than what your column definitions allow.

[fenway]

An example of the insert statement and the table definition would help, too.

[FoxRocks]

You tried to put in data that was longer than what your column definitions allow.

 

4 years later and this helped me thanks!

[deo]

while uploading an excel i got this error it was not a back end issue excel uploaded was having large space in one column before the double value

 

like:

isbn         mrp

323232   121

21212                 3232

Edited August 30, 2013 by deo