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

This article mainly introduces the query skills and methods of MySQL, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand the query skills and methods of MySQL.

1) get the data of the specified offset

SELECT * FROM alarm LIMIT 0pr 9

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

Explanation:

"0": represents the starting position of the data acquisition. (0 represents the first record, which is incremented)

"9": the number of records expected to be obtained.

Indicates that the result of the query is obtained from the first record, and the number of records obtained does not exceed 9.

Maybe when the total number of records in the database is less than 9, the actual number of records is the final number of records.

After reading the above query techniques and methods about MySQL, many readers must have some understanding. If you need more industry knowledge and information, you can continue to pay attention to our industry information column.

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.