摘要:
SELECT * FROM information_schema.INNODB_LOCKs; SELECT * FROM information_schema.INNODB_LOCK_waits; SELECT * FROM information_schema.INNODB_TRX; kill t 阅读全文
摘要:
with myT as( select id ,parent_id from organization ), myT2 as( select * from myT where parent_id in(#{upperId}) union all select myT.* from myT2 inner join myT on myT2.id=myT.parent_id ) select u.... 阅读全文
摘要:
select CASE r.rule_category WHEN '1' THEN '温度' WHEN '2' THEN '湿度' WHEN '3' THEN '气压' ELSE '未知' END+r.name as name,r.ruleIds from ( select rule_cate... 阅读全文