mysql> update T_USER set ADDRESS ='aaa' where userid= 1;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: '96133dby11'
出错原因：where条件中的值传入了错误的数据类型。userid是varchar类型的，我却传入了int类型值。
mysql> update T_USER set ADDRESS ='aaa' where userid= '1';
Query OK, 0 rows affected (0.08 sec)
Rows matched: 0 Changed: 0 Warnings: 0
转载请注明原文地址: https://ju.6miu.com/read-1302933.html
