MySQL uses the select statement to query the data of the specified column (field) in the specified table

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 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';
+-------+------------+
| t_name | t_birth |
+------- +----------------+
| name2 | 2013-01-01 |
+-------+------------ +
1 rows in set (0.00 sec)

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!