The SELECT
statement is used to pull information from a table. SELECT
语句用于从表中提取信息。The general form of the statement is:声明的一般形式为:
SELECTwhat_to_select
FROMwhich_table
WHEREconditions_to_satisfy
;
what_to_select
indicates what you want to see. what_to_select
表示您希望看到的内容。This can be a list of columns, or 这可以是列的列表,也可以*
to indicate “all columns.” *
,表示“所有列”。which_table
indicates the table from which you want to retrieve data. which_table
表示要从中检索数据的表。The WHERE
clause is optional. WHERE
子句是可选的。If it is present, 如果存在,则conditions_to_satisfy
specifies one or more conditions that rows must satisfy to qualify for retrieval.conditions_to_satisfy
指定行必须满足的一个或多个条件,以符合检索条件。