https://github.com/XiaoMi/soar
echo 'select * from film' | ./soar
eg:
echo 'SELECT A.*,if(B.num is null,0,B.num) as fitness_num,`C`.`username` FROM `fa_companies` `A` LEFT JOIN ( SELECT company_id,count(1) as num FROM `fa_fitness` WHERE `status` = 0 GROUP BY `company_id` ) `B` ON `A`.`id`=`B`.`company_id` LEFT JOIN ( SELECT `id`,`username`,`company_id` FROM `fa_user` WHERE `fitness_id` = 0 AND `company_id` <> 0 ) `C` ON `A`.`id`=`C`.`company_id` WHERE ( C.id in ( SELECT `user_id` FROM `fa_admin_user_role_relations` WHERE `roles_id` = 7 ) ) ORDER BY `A`.`id` DESC' | ./soar
版权声明：本文为weixin_41497075原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。