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';
标签:status,userid,00,导出,excel,keyusage,user,MySQL,department From: https://www.cnblogs.com/shaoing/p/17777273.html