SQL的CRUD记录

- mysql
插入语句：insert into table_a(item1, item2, item3) select b.item2, b.item1, b.item5
from table_b b where b.item4=’insert’
更新语句：update table_a a, table_b b set a.item_1=b.item_2
where a.item_2=b.item_5
- sqlserver
插入语句：
更新语句：update tableA set item1=b.item2
from tableB b, tableC c
where b.item5=c.item4
- oracle