fantomel Posted September 27, 2008 Share Posted September 27, 2008 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 Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 27, 2008 Share Posted September 27, 2008 You tried to put in data that was longer than what your column definitions allow. Quote Link to comment Share on other sites More sharing options...
fenway Posted September 29, 2008 Share Posted September 29, 2008 An example of the insert statement and the table definition would help, too. Quote Link to comment Share on other sites More sharing options...
FoxRocks Posted November 15, 2012 Share Posted November 15, 2012 You tried to put in data that was longer than what your column definitions allow. 4 years later and this helped me thanks! Quote Link to comment Share on other sites More sharing options...
deo Posted August 30, 2013 Share Posted August 30, 2013 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.