MYSQL查询男女数量的存储过程
存储过程代码:
BEGIN IF sex_id =0 THEN SELECT COUNT(*) FROM mybatis.p_user WHERE p_user.sex='女' INTO sex_count; ELSE SELECT COUNT(*) FROM mybatis.p_user WHERE p_user.sex='男' INTO sex_count; END IF; END
条件:
IN `sex_id` int,OUT `sex_count` int
执行:
SET @sex_count=0; CALL mybatis.user_count(1,@sex_count); SELECT @sex_count;
//可设置别名 SELECT @sex_count count;
结果: