分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
mysql更新时,要更新记录中某个区间的数据,只能用WHERE条件来限制了,
用LIMIT只能限制更新多少条!测试如下:
UPDATE products SET goods_number = goods_number+10 ORDER BY goods_id DESC LIMIT 5,10
上面这句测试了是错误的,MYSQL的UPDATE语句不能更新限制从第几条到第几条!
错误提示:#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10' at line 1
只能用下面这样的语句了,要么你就用where条件语句来限制了
UPDATE products SET goods_number = goods_number+10 ORDER BY goods_id DESC LIMIT 10
用LIMIT只能限制更新多少条!测试如下:
UPDATE products SET goods_number = goods_number+10 ORDER BY goods_id DESC LIMIT 5,10
上面这句测试了是错误的,MYSQL的UPDATE语句不能更新限制从第几条到第几条!
错误提示:#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10' at line 1
只能用下面这样的语句了,要么你就用where条件语句来限制了
UPDATE products SET goods_number = goods_number+10 ORDER BY goods_id DESC LIMIT 10
给我老师的人工智能教程打call!http://blog.csdn.net/jiangjunshow
![这里写图片描述](https://i-blog.csdnimg.cn/blog_migrate/2e19ffb3303a490d20ea5d00dd397156.gif)