mysql INSERT statement

UK[ɪnˈsɜ:t] US[ɪnˈsɜ:rt]

##vt.Insert; embed; (in the article) add; insert

n.Insert; addition (especially a small picture inserted or overprinted in a page of printed matter); insert (of a book or newspaper); addition

Third person singular: inserts Present participle: inserting Past tense: inserted Past participle: inserted

mysql INSERT statement syntax

Function:Used to insert new rows into the table.

Syntax:INSERT INTO table name VALUES (value 1, value 2,....) or INSERT INTO table_name (column 1, column 2,...) VALUES (value 1 , value 2,....)

mysql INSERT statement example

//向persons表中插入新的数据 INSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing'); //向指定的列插入新的数据 INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees');