sql

1、select tbl.tenant id,(case
when tbl.useinfo >10000 then '10000以上'
when(tbl.useinfo between 5000 and 10000)then '5000~10000'
when tbl.useinfo <10 then'10以下'
end)as useinfotype from XXX
2、substr(cancel time,1,10)
3、update yzg trans.tms driver set driver level=null where driver level is not null;
4、SEIECT TABLE SCHEMA FRoM information schema.TABLEs WHERE table name = 'ybd project route driver rel'
5、SELECT GROUP CONCA(district code SEPARAToR')As district codesFRoM tms cargo.ybd business area range where business area id =231010111912118850 and is valid =lROUP BY business area id;
6、SELECT extra info->'$.agentDriverYbdBonusReason' from tms trade.ybd fee item where id-44select DATE FORMAT (curdate(),"$x-&m-d SH:&i:&S'),nOw(),DATE ADD(CUrdate(), INERVAL 1 DAY),DATE AD(Curdate(), INTERVAL 1 HOUFSELECT 1(1=1,true',false')as result from xxxxx
7、INSERT INTo yzg youpin.assign order(cargo id)VALUES(10169008270325)
8、EXPLAIN SELECT*FROM users WHEREusername ='example user';type字段应该是ref或const，表示非全表扫描
9、SHOW INDEX RM table name;
10、SHOW VARIABLES IKE'slow guery log';SHOW VARIABLES LIKE 'slow guery log file';SHOW VARIABLES LIKE 'long querytime';