php - 如何在同一个sql查询中检查多个sql查询

Question

如何检查多个 sql 查询，如果一个错误则运行第二个查询，如果第二个错误则运行第三个。怎么做。我感到很困惑。

SELECT (SELECT COUNT(u.`global`) 
        FROM user u 
        WHERE u.global = user.user_id AND launch=1 )as done , user_id  
FROM user HAVING done < 6

如果此为假，则运行此 sql 查询:-

SELECT (SELECT COUNT(u.`global`) 
     FROM user u 
     WHERE u.global = user.user_id AND launch=1 )as done , user_id  
FROM user HAVING done > 7

Answer 1

您可以使用简单的按用户计数分组并使用 OR(和分组依据)来检查两个具有条件

 SELECT COUNT(u.`global`) done,  u.user_id
 from user u
 group by user_id
 having  done <6 or done >7