Home > Database > Mysql Tutorial > mysql advanced (7) usage of limit

mysql advanced (7) usage of limit

黄舟
Release: 2017-02-09 15:23:22
Original
1123 people have browsed it

limit is the syntax of MySQL

select * from table limit m,n
Copy after login

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 (m.sbmmt.com)!


Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template