mysql SELECT statement

英[sɪˈlekt] 美[sɪˈlɛkt]

vt.Select; select; select

adj. Selected; selected; harshly selected; <口> like to pick three Picky, picky

Third person singular: selects Present participle: selecting Past tense: selected Past participle: selected

mysql SELECT statement syntax

Function: Used to select data from the table. The results are stored in a results table (called a result set).

Syntax: SELECT column name FROM table name and SELECT * FROM table name

Note: SQL statements are not case sensitive. SELECT is equivalent to select.

mysql SELECT statement example

//获取persons表中LastName和FirstName列的内容
SELECT LastName,FirstName FROM Persons;