Hi Everybody. I have a funny problem: I'm getting thousands of "Data Truncated" warnings when I insert a single row of data into a table, using an INSERT...SELECT.
The funny thing is, the warning is for a column I'm not even inserting. It's only a column that I'm doing a join on. The query is this: INSERT INTO customers (id) SELECT null FROM statistics.user LEFT JOIN statistics.user dup_user ON dup_user.domain_id=user.domain_id AND dup_user.user_id>user.user_id AND user.email=dup_user.email LIMIT 1; +---------+------+--------------------------------------------+ | Level | Code | Message | +---------+------+--------------------------------------------+ | Warning | 1265 | Data truncated for column 'email' at row 1 | +---------+------+--------------------------------------------+ (MySQL on a SuSE 9 box, tested with both 4.0.18-standard and 4.1.2-alpha- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
