hcd1129的博客

进入MySQL命令行 黑窗口：进到mysql的安装目录bin的目录下 C:\mysql\mysql-8.0.16-winx64\bin>mysql -u root -p Enter password: Navicat：F6进入命令窗口 使用mysql库 mysql> use mysql 创建用户 mysql> create user 'test2'@'%' identified by '123456'; Query OK, 0 rows affected (0.01 sec)

统计本月数量和今天数量 SELECT count(if(DATE_FORMAT(create_time,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m'),true,null)) AS thisMonthTotal, count(if(TO_DAYS(create_time) = TO_DAYS(NOW()),true,null)) AS thisDayTotal FROM demo