UPDATE shop_category SET name = 'Secolul XVI - XVIII' AND name_eng = '16th to 18th centuries' WHERE category_id = 4768 category_id mediumint(8) name varchar(250) name_eng varchar(250)

執行報錯

1292 - Truncated incorrect DOUBLE value: 'Secolul XVI - XVIII'

問題原因，update不應該用and，修改sql語句為

UPDATE shop_category SET name = 'Secolul XVI - XVIII', name_eng = '16th to 18th centuries' WHERE category_id = 4768

?

轉載于:https://www.cnblogs.com/dashuai01/p/8978073.html

總結

以上是生活随笔為你收集整理的mysql修改Truncated incorrect DOUBLE value:的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。