mysql执行sql语句update报错:
UPDATE main_data_status SET update_time='2016-10-20 10:22:36',amount='600万',ROUND='A轮',currency='美元'
WHERE product_uuid=275181
[Err] 1292 - Truncated incorrect DOUBLE value: 'c5dbc300-6e56-4ef7-9644-78b1fbf47668'
找到原因,是因为product_uuid 为varchar类型,如果长度过长的int就会导致此种错误发生,解决办法:
UPDATE main_data_status SET update_time='2016-10-20 10:22:36',amount='600万',ROUND='A轮',currency='美元'
WHERE product_uuid=‘275181‘