insert into studen select * from socre where name=‘zhangsan’ --插入一行,要求表studen 必须存在
select * into studen from score where name=‘zhangsan’ --也是插入一行,要求表studen 不存在
sql 语句 insert into select 和select into from 的区别
最新推荐文章于 2024-02-20 10:50:51 发布
insert into studen select * from socre where name=‘zhangsan’ --插入一行,要求表studen 必须存在
select * into studen from score where name=‘zhangsan’ --也是插入一行,要求表studen 不存在