free玩弄少妇,成年美女黄网站色大免费视频

Home

php教程

PHP開發(fā)

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

高洛峰

Jan 03, 2017 pm 04:30 PM

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':

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 of this Website

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