代码如下:
SET @ins=CONCAT('select *from liu limit ',((2-1)*5),',',5,'');
PREPARE prep FROM @ins;
EXECUTE prep;
运行后 如下图:
![](https://i-blog.csdnimg.cn/blog_migrate/1850f71a3908cc87b12976cb7c182115.png)