mysql一张表两个字段互换
update product as a, product as b set a.original_price=b.price, a.price=b.original_price where a.id=b.id;
代码地址:https://blog.csdn.net/fdipzone/article/details/50864196
上一篇:
mysql 避免记录重复插入
下一篇:
form表单mysql防#号注入
友情提示:垃圾评论一律封号...