mysql INSERT statement
Translation results：
UK[ɪnˈsɜ:t] US[ɪnˈsɜ:rt]
##vt.Insert; embed; (in the article) add; insertn.Insert; addition (especially a small picture inserted or overprinted in a page of printed matter); insert (of a book or newspaper); additionThird person singular: inserts Present participle: inserting Past tense: inserted Past participle: insertedmysql INSERT statementsyntax
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 statementexample
//向persons表中插入新的数据
INSERT INTO Persons VALUES ('Gates', 'Bill', 'Xuanwumen 10', 'Beijing');
//向指定的列插入新的数据
INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees');