- 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
SQL的CRUD记录
最新推荐文章于 2024-07-15 10:51:55 发布