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;