Truncated incorrect DOUBLE value: ‘是’
0.背景
mybaits运行sql报错(update语句),发现也是基本(愚蠢)的错误。
>1292 – Truncated incorrect DOUBLE value: ‘是’
错误的SQL语句:
update contractor set approve = '是' and contract = '12314'
WHERE Id = '04035';
错误原因,and用法写错。
正确写法:
update contractor set approve = '是' , contract = '12314'
WHERE Id = '04035';
改成逗号就好了。