Click here to Skip to main content
971 members (203 online)
Click here to Skip to main content
Add your own
alternative version

Stats

2.3K views
Posted 17 Mar 2012

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

, 17 Mar 2012
Rate this:
Please Sign up or sign in to vote.
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)

Share

About the Author

Alberto León
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.

You may also be interested in...

Comments and Discussions

 
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
RA-Web1 | 2.8.171114.1 | Last Updated 17 Mar 2012
Article Copyright 2012 by Alberto León
Everything else Copyright © RootAdmin, 1999-2017
Layout: fixed | fluid