Shulou(Shulou.com)06/01 Report--

1) Get data for specified offset

SELECT * FROM alarm LIMIT 0,9;

SELECT * FROM alarm LIMIT 9 OFFSET 0; (supported after mysql 5)

Explanation:

"0": represents the starting position of data acquisition. (0 stands for the first record, and increments accordingly)

"9": Number of records expected to be fetched.

Indicates that query results are obtained starting from the first record, and the number of records obtained does not exceed 9.

If the total number of records in the database is less than 9, then the actual number of records is the final number of records.

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.