Shulou(Shulou.com)06/02 Report--

Most people do not understand the knowledge of this article "mybatis plus QueryWrapper how to add limit", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "mybatis plus QueryWrapper how to add limit" article.

QueryWrapper add limit

In fact, limit-related statements are added at the end of sql.

QueryWrapper wrapper = new QueryWrapper (); wrapper.last ("limit 1"); limit error occurred in mybatis paging

When there is no problem code repeatedly, please check your SQL statement! (check carefully)

SELECT * FROM student

Please take a look at the problem with this SQL statement: it was at the end that I wrote a semicolon.

This causes the sql statement to be as follows:

Select * from student;limit 1,3

All will report an error.

The above is about the content of this article on "how to add limit to mybatis plus QueryWrapper". I believe we all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.