Home >Database >Mysql Tutorial >mysql advanced (7) usage of limit
mysql advanced (7) usage of limit
- 黄舟Original
- 2017-02-09 15:23:221131browse
limit is the syntax of MySQL
select * from table limit m,n
where m refers to the index where the record starts, starting from 0, indicating the first record
n refers to the index starting from m+1 Starting from bar, take n bar.
select * from tablename limit 2,4
That is, take out the 3rd to 6th records, 4 records.
The above is the usage of mysql advanced (seven) limit. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!
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 Advanced (6) Introduction to Four Usage of Fuzzy QueryNext article：MySQL Advanced (6) Introduction to Four Usage of Fuzzy Query