INSERT INTO 语句
INSERT INTO 语句用于向表格中插入新的行。
语法
INSERTINTO表名称VALUES(值1,值2,....)
我们也可以指定所要插入数据的列:
INSERTINTOtable_name(列1,列2,...)VALUES(值1,值2,....)
插入新的行
"Persons" 表:
LastName | FirstName | Address | City | Carter | Thomas | Changan Street | Beijing |
SQL 语句:
INSERTINTOPersonsVALUES('Gates','Bill','Xuanwumen10','Beijing')
结果:
LastName | FirstName | Address | City | Carter | Thomas | Changan Street | Beijing | Gates | Bill | Xuanwumen 10 | Beijing |
在指定的列中插入数据
"Persons" 表:
LastName | FirstName | Address | City | Carter | Thomas | Changan Street | Beijing | Gates | Bill | Xuanwumen 10 | Beijing |
SQL 语句:
INSERTINTOPersons(LastName,Address)VALUES('Wilson','Champs-Elysees')
结果:
LastName | FirstName | Address | City | Carter | Thomas | Changan Street | Beijing | Gates | Bill | Xuanwumen 10 | Beijing | Wilson | Champs-Elysees |