Shulou(Shulou.com)05/31 Report--

Most people do not understand the knowledge points of this article "what is the query method of mysql select?", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "what is the query method of mysql select" article.

Description

1. In a query, you can use one or more tables, split them with commas (,), and use WHERE to set query conditions.

2. The SELECT command can read one or more records.

You can replace other fields with a star (*), and the SELECT statement returns all the field data of the table.

You can use the where statement to include any condition.

You can use the LIMIT property to set the number of records returned.

You can specify the data offset at which the query starts with the SELECT statement through OFFSET. The offset is 0 by default.

Example

SELECT column_name,column_nameFROM table_ name [where Clause] [LIMIT N] [OFFSET M] the above is the content of this article on "what is the query method of mysql select?" I believe you all have a certain understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

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.