1.MySQL数据被锁了快速,直接解决办法
强制重启数据库(注:该操作必须谨慎,重启数据库时间段内,所有业务将不能操作)
2.mysql case when 用法
(1)与sum结合使用
SELECT
SUM( num ),
SUM( CASE WHEN u.`status` = 0 THEN num END ) zeroCount,
SUM( CASE WHEN u.`status` = 1 THEN num END ) oneCount,
SUM( CASE WHEN u.`status` = 9 THEN num END ) twoCount
FROM
t_verification u;
(2)与count结合使用
SELECT
COUNT(1),
COUNT( CASE WHEN u.`status` = 0 THEN '' END ) zeroCount,
COUNT( CASE WHEN u.`status` = 1 THEN '' END ) oneCount,
COUNT( CASE WHEN u.`status` = 9 THEN '' END ) twoCount
FROM
t_verification u;