Home >Database >Mysql Tutorial >mysql分布式和分区limitoffset加速_MySQL
mysql分布式和分区limitoffset加速_MySQL
- WBOYOriginal
- 2016-06-01 13:26:48821browse
bitsCN.com
前一段时间在写分页语句。单机的mysql一般使用:
select * from [table] limit [length] offset [offset]
select * from [table] where column > [pre_column_value] limit [length]
select * from [table] where key_column > [pre_key_column_value] order by key_column limit [length]bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL读写分离_MySQLNext article：Tomcat7.0连接mysql5.0_MySQL