38
你知道MySQL的Limit有性能问题吗
source link: https://juejin.im/post/5cd2d57951882540d928c2be
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
MySQL的分页查询通常通过limit来实现。 MySQL的limit基本用法很简单。limit接收1或2个整数型参数，如果是2个参数，第一个是指定第一个返回记录行的偏移量，第二个是返回记录行的最大数目。初始记录行的偏移量是0。 为了与PostgreSQL兼容
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK