mysql - MYSQL 未知列但列存在 varchar 是时间戳

Question

下面的代码正在工作

 SET @row := 0;
SELECT CONCAT(@row := @row + 1,' ',ui.firstname, ui.mname, ui.lastname) as 'FullName',
d.survey_at_what_blh, ui.status, ui.nature_of_work, ui.level, ui.course_or_section
FROM (select distinct survey_at_what_blh, userid from daily_report) d INNER JOIN userinfo ui ON d.userid = ui.id    

但是当我像这样添加 d.date_opened

 SET @row := 0;
SELECT CONCAT(@row := @row + 1,' ',ui.firstname, ui.mname, ui.lastname) as 'FullName',
d.survey_at_what_blh, ui.status, ui.nature_of_work, ui.level, ui.course_or_section,  d.date_opened
FROM (select distinct survey_at_what_blh, userid from daily_report) d INNER JOIN userinfo ui ON d.userid = ui.id  

它在“字段列表”中显示“未知列'd.date_opened”，但此处确实存在该列是我的列的图像。为什么不显示？你们能给我一个线索或提示我做错了什么吗

点击这里查看我的数据库

标签： mysql

Answer 1

你date_opened在这里错过：

设置@row := 0; SELECT CONCAT(@row := @row + 1,' ',ui.firstname, ui.mname, ui.lastname) as 'FullName', d.survey_at_what_blh, ui.status, ui.nature_of_work, ui.level, ui。 course_or_section，d.date_opened FROM（从daily_report中选择不同的survey_at_what_blh，userid date_opened）d INNER JOIN userinfo ui ON d.userid = ui.id