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