SQL的常用语句
select * from g_members where id between '16' and '31' order by id desc 倒序排列
select * from g_members_thirdparty where uid in(select id from g_members where mobile='13438342547')
select * from g_members where email in (select DISTINCT email from g_members)
select * from g_members where id='16' and mobile='1882154647'
select * from g_members where id='16' or mobile='1882154647'
select * from g_members where mobile='18780010265' insert into g_members (mobile)values('13178849632')
insert into g_members values('1607001','13178849632') 向表里插入数据,需要的数据都需插入
update g_members set mobile='110' where mobile='13178849632'
DELETE from g_members where mobile='110'
select g_members.id,g_members.mobile,g_members_thirdparty.tokenkey from
g_members join g_members_thirdparty on g_members.id=g_members_thirdparty.uid
select * into test from g_members (sql中使用此语句)
create table test(select * from g_members)(MYSQL中使用此语句)
最新文章
- LoadRunner ---协议分析
- 知方可补不足~Sqlserver中的几把锁和.net中的事务级别
- 【转】linux之mkfs/mke2fs格式化
- 学习JSONP
- Django开发网站(四)
- TableView不显示没内容的Cell怎么办?
- bzoj3667: Rabin-Miller算法
- 【转】HTML5 LocalStorage 本地存储
- 建立ORACLE10G DATA GUARD---&;gt;Physical Standby
- java调用dll-JNA
- 数据可视化 seaborn绘图(2)
- 周强 201771010141《面向对象程序设计(java)》第四周学习总结
- Codeforces Round #554 (Div. 2)-C(gcd应用)
- @Scheduled 定时
- git-04 同意分支合并
- python基础学习5----字典
- Mistakes I Made(as a developer)...大龄程序员的忠告...(部分转...)
- A股和B股票的区别?
- python3 列表的常用方法
- 对不队——Alpha冲刺