mysql 分页错乱_MYSQL 分页异常了

mysql 分页错误了

mysql> select * from b;

+------+------+-------+

| id | name | bumen |

+------+------+-------+

| 2400 | a | 1 |

| 2300 | b | 1 |

| 2200 | a | 2 |

| 2200 | b | 2 |

+------+------+-------+

4 rows in set (0.00 sec)

mysql> select top 2 * from b order by id;

ERROR 1064 (42000): 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 '2 * f

rom b order by id' at line 1

错了

------解决方案--------------------

MySQL 中不是TOP，是LIMIT

SQL code

select * from b order by id limit 2;

欢迎大家阅读《MYSQL 分页异常了》,跪求各位点评，by 搞代码

原创文章，转载请注明： 转载自搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~