mysql教程:limit在update和delete语句中也是可以使用
语法代码案例如下:
- -- 前3名语文成绩加1分
- mysql> update stu set ch=ch+1 order by ch+math desc limit 3;
- Query OK, 3 rows affected (0.00 sec)
- Rows matched: 3 Changed: 3 Warnings: 0
- -- 前3名删除
- mysql> delete from stu order by ch+math desc limit 3;
- Query OK, 3 rows affected (0.00 sec)
复制代码
|
|