The SELECT statement is used to pull information from a table. SELECT语句用于从表中提取信息。The general form of the statement is:声明的一般形式为:
SELECTwhat_to_selectFROMwhich_tableWHEREconditions_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指定行必须满足的一个或多个条件,以符合检索条件。