学院考勤

登录数据库界面

点击 SQL

填入 SQL 语句和想要查询的时间

explain SELECT SQL_NO_CACHE distinct b.yb_userid ,c.yb_username,c.yb_realname,c.yb_collegename,c.yb_classname,DATE_FORMAT(a.createTime,"%Y-%m") as time
FROM glutlife.app_tongji_login  as a
join glutlife.userinfo as b  on b.id=a.userid
join glutlife.yiban_userinfo as  c on b.yb_userid= c.yb_userid
WHERE UNIX_TIMESTAMP(a.createTime)>UNIX_TIMESTAMP('2020-11-05') AND UNIX_TIMESTAMP(a.createTime)<UNIX_TIMESTAMP('2020-12-05')

点击执行。稍等大概十几秒，因为数据量较大。web 界面反应也需要时间。

点击导出，进行下一步操作。