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

The basic usage of MySQL SELECT statement

Among the database operation statements, the most frequently used and considered the most important is the SELECT query statement, whose syntax is "SELECT * FROM table_name", in which the "*" represents all the fields to be queried, and the "table_name" represents the table to be queried.

The basic format of the SELECT statement is:

Column name to be queried by SELECT FROM table name WHERE constraint

SELECT statements often have WHERE constraints that are used to achieve more accurate queries. WHERE constraints can have mathematical symbols (=, > =, 25

Or look for the name,age and phone of an employee named Mary:

SELECT name,age,phone FROM employee WHERE name='LLODY'

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.