数据库 操作语言 DML
1 . insert
insert into table (column.column) values (value,value)
insert into table values (所有字段的值 按顺序)
还可以从别的表查来数据插入
2. update
update table set column = value,column=value... where condition;
3.delete
delete table ; delete from table ; delete table where condition;
4.merge
merge into table [alias]
using (table | view | sub_query ) [alias]
on (join_condition)
where matched then
update set coll = coll_val,col2=col2+val
when matched then
insert (column_list) values (column_values);
merger语句用于进行数据合并--根据条件在表中执行数据的修改或者插入操作,如果要插入的记录在目标表中已经存在,则执行更新操作,否则执行插入操作。