www.ctrt.net > mysql全部有100多个数据库和N个表,怎么查关键字lo...

mysql全部有100多个数据库和N个表,怎么查关键字lo...

查询符合条件的值 select * from C c1 left join B b1 on c1.id=b1.exID where c1.UID=b1.UID and c1.LI=101 and b1.LO is null 计算和 select sum(c1.LI) from C c1 left join B b1 on c1.id=b1.exID where c1.UID=b1.UID and c1.LI=101 and b1...

网站地图

All rights reserved Powered by www.ctrt.net

copyright ©right 2010-2021。
www.ctrt.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com