MySQL uses the select statement to query the data of the specified column (field) in the specified table
- 高洛峰Original
- 2017-01-03 16:30:543263browse
This article introduces the execution of the select query statement in the MySQL database to query the data of the specified column, that is, the data of the specified field.
Let’s review the syntax of the select statement in the SQL statement:
The basic syntax of the Select statement:
Select If you want to query all the data in a specified column in a table, the query statement can be written as: select Column name 1, column name 2, column name 3... from To explain, you can still use the where clause after this statement to select the specified column of the specified row. In this way, the required results can be queried more accurately. Let's look at an example below, query the data of the two fields t_name and t_birth in the test table, and match the row t_name='name2': mysql> select t_name,t_birth from test where t_name='name2'; About MySQL using the select statement to query the data of the specified column (field) in the specified table, this article will introduce so much. I hope it will be helpful to everyone, thank you! For more articles related to MySQL using the select statement to query the data of the specified column (field) in the specified table, please pay attention to the PHP Chinese website! order by
+-------+------------+
| t_name | t_birth |
+------- +----------------+
| name2 | 2013-01-01 |
+-------+------------ +
1 rows in set (0.00 sec)