Shulou(Shulou.com)05/31 Report--

What is the difference between limit and offset in mysql? I believe many inexperienced people don't know what to do about it. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

The picture above shows all the data in the T1 table.

For example, this Sql statement fetches 2 pieces of data backward from the first piece of data, limit 2 indicates that the number of data fetched is two, and offset 1 indicates that it starts from the first piece of data (the index of the program starts from 0).

After this SQL,limit, it is indicated that the data is fetched backward from Article 2 and a piece of information is taken.

After reading the above, have you mastered the difference between limit and offset in mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.