简体中文（ZH-CN）English（EN）繁体中文（ZH-TW）日本語（JA）한국어（KO）Melayu（MS）Français（FR）Deutsch（DE）
Home
Article
Q&A
Course
Topic
Download
Game
Dictionary
Recent Updates

Home  >  Article  >  php教程  >  MySQL uses the select statement to query the data of the specified column (field) in the specified table

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

高洛峰
高洛峰Original
2017-01-03 16:30:543182browse

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

order by

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';
+-------+------------+
| 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!

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：A brief discussion on precautions when using the splice function to delete elements in an arrayNext article：A brief discussion on precautions when using the splice function to delete elements in an array

Related articles

See more