Click here to Skip to main content
1,837 members
Articles / Multimedia / SQL
Tip/Trick

MySQL throws Data trucanted for column 'colum name' at row n...

Rate me:
Please Sign up or sign in to vote.
0.00/5 (No votes)
17 Mar 2012CPOL 5.8K  
Is not an error. Is an alert because MySQL rounded or trim the data you want to update

Some times we confuse an alert with an error.

The text "Data trucanted for column 'colum name' at row n..." indicates that the data you want to set to update a column has more decimals than the expected or in the case of string is longer thant the expected.

 No error happened. But You should to check after update if the data stored is your desired values. 

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Technical Lead Get Me An Apartment
Spain Spain
This member doesn't quite have enough reputation to be able to display their biography and homepage.

Comments and Discussions

 
-- There are no messages in this forum --