MySQL Forums
Forum List  »  Newbie

Data truncated for column 'xy' at row 'nbr'
Posted by: ThomasKHill
Date: July 01, 2005 12:36PM

When altering a column definition of an InnoDB table I got warnings:
!error 1005 data truncated for column 'xy' at row 5
!error 1005 data truncated for column 'xy' at row 15
... and so on
when the query was executed using query browser 1.1.10.

If I would like to see the rows in which the values got truncated - how do I retrieve them? In other words how are the rows numbered? How do I find out which row is row number 5 amd which row number 15 ....? What is a row number?

(It can not be the rows with a value 5 in the primary key field)

query browser 1.1.10 on win xp MySQL 5.0.7

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Data truncated for column 'xy' at row 'nbr'
July 01, 2005 12:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.