Go homepage(回首页)
Upload pictures (上传图片)
Write articles (发文字帖)

The author:(作者)归海一刀
published in(发表于) 2014/2/3 6:39:30
SQL初学者教程:掌握学会INSERT INTO 语句_[SQL Server教程]

SQL初学者教程:掌握学会INSERT INTO 语句_[SQL Server教程]


INSERT INTO 语句


INSERT INTO 语句用于向表格中插入新的行。


语法

INSERT INTO table_name
VALUES (value1, value2,....)

我们也可以指定所要插入数据的列:

INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)


插入新的行


"Persons" 表:


LastName
FirstName
Address
City
Pettersen
Kari
Storgt 20
Stavanger

SQL 语句:

INSERT INTO Persons
VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')

结果:


LastName
FirstName
Address
City
Pettersen
Kari
Storgt 20
Stavanger
Hetland
Camilla
Hagabakka 24
Sandnes


在指定的列中插入数据


"Persons" 表:


LastName
FirstName
Address
City
Pettersen
Kari
Storgt 20
Stavanger
Hetland
Camilla
Hagabakka 24
Sandnes

SQL 语句:

INSERT INTO Persons (LastName, Address)
VALUES ('Rasmussen', 'Storgt 67')

结果:


LastName
FirstName
Address
City
Pettersen
Kari
Storgt 20
Stavanger
Hetland
Camilla
Hagabakka 24
Sandnes
Rasmussen
Storgt 67







If you have any requirements, please contact webmaster。(如果有什么要求,请联系站长)





QQ:154298438
QQ:417480759