How does mysql query the data of a field in the database?

How to query a certain field in the database in mysql: use the SELECT statement, use the “SELECT FROM ;” syntax to query; if you want to query multiple fields, use different field names Separate them with a comma “,”. In MySQL, you can use the SELECT statement to query data. Querying data refers to using different query methods to obtain different data from the database according to requirements, which is the most frequently used and most important operation. The syntax of SELECT is as follows: SELECT {* | } [ FROM , … [WHERE [GROUP BY [HAVING [{ }…]] [ORDER BY ] [LIMIT[,] ] ] Among them, the meaning of each clause is as follows: {*| } A field list containing asterisk wildcards, indicating the name of the field to be queried. , …, Table 1 and Table 2 indicate the source of query data, which can be single or multiple. WHERE is optional, if you select this item, the query data must meet the query condition. GROUP BY, this clause tells MySQL how to display the queried data and group it by the specified field. [ORDER BY], this clause tells MySQL in what order to display the queried…