多表更新錯誤
mysql> UPDATE tdb_goods INNER JOIN tdb_goods_cates ON goods_cate
? ? -> SET goods_cate=cate_id;
ERROR 1292 (22007): Truncated incorrect INTEGER value: '筆記本'
1 回答
舉報
0/150
提交
取消
mysql> UPDATE tdb_goods INNER JOIN tdb_goods_cates ON goods_cate
? ? -> SET goods_cate=cate_id;
ERROR 1292 (22007): Truncated incorrect INTEGER value: '筆記本'
2019-04-23
舉報
2019-04-29
ON goods_cate = cate_name你漏了等號后面的這些