![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
iteye_18435
这个作者很懒,什么都没留下…
展开
-
select into 和 insert into的简单区别
现有表t1, t2 select into: select * into t3 from t1; 也就是说select into会将查询结果保存到临时表t3中 insert into: insert into t2(column1, column2, ....) select column1, column2, .... from t1 insert into 会将查询结果保存到已...2008-11-19 15:26:09 · 258 阅读 · 0 评论 -
sql查询关建字之-exists, in. all, any, some
[b]SQL中exists和in的区别[/b] 两张表——用户表TDefUser(userid,address,phone)和消费表TAccConsume(userid,time,amount),需要查消费超过5000的用户记录。 用exists: select * from TDefUser where exists (select 1 from TAccConsume where ...2008-11-21 13:02:25 · 111 阅读 · 0 评论