SET FOREIGN_KEY_CHECKS = 0;
update goods set id=160256 where id='200062';
update goods_sku set goods_id=160256,id=60256 where id='200626';
SET FOREIGN_KEY_CHECKS = 1;
mysql 更改两表相关联的字段值,关闭外键约束
SET FOREIGN_KEY_CHECKS = 0;
update goods set id=160256 where id='200062';
update goods_sku set goods_id=160256,id=60256 where id='200626';
SET FOREIGN_KEY_CHECKS = 1;
mysql 更改两表相关联的字段值,关闭外键约束