第七部分 数据的更新
1. 插入INSERT
INSERT [INTO]
{Table_name WITH (<table_hint_limited> […n]) | view_name | rowset_function_limited}
{
[(column_list)]
{VALUSE({DEFAULT | NULL |xepression} [,…n]) | derived_table | execute_statement}
}
2. 修改UPDATE
UPDATE table_name
SET | column_name =|expression |DEFAULT | NULL | [,…,n]|
[FROM table_name[,…]]
[WHERE<search_condition>]
3. 删除数据DELETE
DELETE table_name
[FROM table_name[,…,n]]
[WHERE | <search_conditon>| ]

浙公网安备 33010602011771号