INSERT、DELETE、UPDATE
1、增
INSERT
[INTO] table_or_view_name[(column_list)]
VALUES (expression_list)
举例:Client表(ClientID,ClientName,Sex,NativePlace)
--添加一条数据
INSERT into client (ClientID,ClientName,Sex,NativePlace)
Values(‘10000’,’hhh’,’女’,’中国’)
go
INSERT
[INTO] table_or_view_name[(column_list)]
VALUES (expression_list)
举例:Client表(ClientID,ClientName,Sex,NativePlace)
--添加一条数据
INSERT into client (ClientID,ClientName,Sex,NativePlace)
Values(‘10000’,’hhh’,’女’,’中国’)
go
2、删( DELETE )
DELETE
FROM table_name
[WHERE] serach_condition
举例:Client表(ClientID,ClientName,Sex,NativePlace)
--删除全部数据
DELETE FROM Client
go
--删除一行数据
DELETE FROM Client WHERE ClientID=‘10000’
go
DELETE
FROM table_name
[WHERE] serach_condition
举例:Client表(ClientID,ClientName,Sex,NativePlace)
--删除全部数据
DELETE FROM Client
go
--删除一行数据
DELETE FROM Client WHERE ClientID=‘10000’
go
、修改(UPDATE) UPDATE SET 3 column_name={expression|DEFAULT|NULL} FROM table_name [where search_conditions] 举例:Client表(ClientID,ClientName,Sex,NativePlace) --修改一条数据 UPDATE Client SET ClientName=‘john’ where clientID=‘10000’ go --修改多行数据 UPDATE Client SET Sex=‘男’ go