多表更新错误
mysql> UPDATE tdb_goods INNER JOIN tdb_goods_cates ON goods_cate
-> SET goods_cate=cate_id;
ERROR 1292 (22007): Truncated incorrect INTEGER value: '笔记本'
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
举报