SQL常用语句

一、删除篇
1.删除多个手机号
DELETe FROM 表名 where phone in (15231227,13395309,13634884);
2.删除单个手机号
DELETe FROM 表名 where phone = 189100562;
3.先查括号里的手机号对应user_id，再删除该表的user_id
DELETe FROM 表名 WHERe user_id in (SELECt id from firm_sole_user where phone = 189100532);
二、查询篇
1.查询单个用户
SELECt * 表名 where phone = 12345678
2.查询多个用户in关联
SELECT * 表名 where phone in (135522065,136836083)
3.先查括号里的手机号对应user_id，再查询该表的user_id
SELECT * FROM 表名 WHERe user_id in (SELECt id from firm_sole_user where phone = 135522665)
4.查询多个条件and关联
SELECt * FROM 表名 WHERe user_id = 100228148 and source_id = 11 and channel_related = 6 100004074
三、修改篇
1.set修改内容，where搜索条件
UPDATE 表名 set status = 2 WHERe status = 0
2.这个（status）参数=0的全部改成=2
UPDATE 表名 set status = 2 WHERe status = 0
四、插入篇
1.insert into 库名.表名（新增参数）values (对应参数的内容)
INSERT INTO elephant_core.firm_user_fund_account(id, user_id, balance, locked, consume, create_time)
VALUES (5061, 100228796, 0.00, 0.00, 0.00, ‘2021-08-11 13:43:55’);

写了鞋比较简单的，经常执行的~