MySQL 命令行 导出数据 加状态判断 导出excel格式

SELECT   user.userid,department.`name`,user.username,user.name,user.`email`,keyusage.`productname`,keyusage.`status`,(case when keyusage.status=1 then '申请激活' when keyusage.status=2 then '激活成功' else '激活失败' end) as flag,INET_NTOA(keyusage.`ip`),keyusage.`computerid`,keyusage.`errorcode`,keyusage.`enddate`  FROM keyusage  LEFT JOIN `user` ON user.userid=keyusage.userid INNER JOIN department ON user.`departmentid`=department.`departmentid` WHERE  keyusage.`enddate`>'2022-01-01 00:00:00' into outfile 'keyusage22.xlsx';