SQL
山岫
知易行难,行胜于言
展开
-
mybatis远程连接mysql出现Access denied for user ‘root‘@‘主机名‘报错
mybatis远程连接mysql出现Access denied for user ‘root‘@‘主机名‘报错解决方法:重置root账号密码1、进入MySQLmysql -u root -p2、重置密码update user set password=password("新密码") where user='root';3、刷新权限FLUSH PRIVILEGES(完美解决)...原创 2022-01-12 20:24:22 · 971 阅读 · 0 评论 -
sql分组按条件统计
统计每个班级男生女生数量以及总人数sex:1:男生 2:女生class:班级 (根据班级分组)SELECT COUNT(CASE WHEN (sex = 1) THEN class END) AS 男生 ,COUNT(CASE WHEN (sex = 2) THEN class END) AS 女生,COUNT(id) AS 总人数 FROM sp_student GROUP BY class...原创 2021-12-25 00:02:10 · 2750 阅读 · 0 评论