Mysql未知列[错误] 1054 - '字段列表'中未知列'endo.duodenum2' [英] Mysql unknown column [err] 1054 - unknown column 'endo.duodenum2' in 'field list'
本文介绍了Mysql未知列[错误] 1054 - '字段列表'中未知列'endo.duodenum2'的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这个MySQL命令。
SELECT
endo.ReportDate,
endo.ReportNo,
patient.EMRNo,
patient.PName,
patient.Address,
patient.Age,
patient.Sex,
endo.RefUnit,
endo.Ward,
endo.ProvDiag,
endo.Premed,
CASE endo.Larynx WHEN ' Normal' 那么 endo.Larynx WHEN ' 结果' 那么 CONCAT(endo.Larynx,' :',endo.LarynxF) END AS Larynx,
CASE endo.Esophagus WHEN ' 正常' 那么 endo.Esophagus WHEN ' 结果' 那么 CONCAT(endo.Esophagus,' :',endo.EsophagusF) END AS 食道,
CASE endo。胃 WHEN ' 正常' 那么 endo.Stomach WHEN ' Findings' 那么 CONCAT(endo.Stomach,' :',endo.StomachF) END AS 胃,
CASE endo.Pylorus WHEN ' 正常' 然后 endo.Pylorus WHEN ' 调查结果 THEN CONCAT(endo.Pylorus,' :',endo .PylorusF) END AS Pylorus,
CASE endo.Duodenum1 WHEN ' 正常' 那么 endo.Duodenum1 WHEN ' 结果' 然后 CONCAT(endo.Du) odenum1,' :',endo.Duodenum1F) END AS Duodenum1,
CASE endo.Duodenum2 WHEN ' 正常' 那么 endo.Duodenum2 WHEN ' Findings' 那么 CONCAT(endo.Doudenum2,' :' ,endo.Doudenum2F) END AS Doudenum2,
CONCAT(endo.HpTest ,' ,',endo.HpTestF) AS HpTest,
endo.Biopsy,
endo.Diagnosis,
endo.Advice,
endo.PerformedBy,
endo.SignedBy
FROM
endo
INNER JOIN 患者 ON patient.EMRNo = endo.EMRNo
它给出了错误
[Err] 1054 - 未知列' endo.Duodenum2' in ' 字段列表'
,我有一张这样的桌子:
[IMG] http://i65.tinypic.com/qzku95.jpg [/ IMG]
我似乎无法找到问题..任何帮助将不胜感激
我有什么试过:
在互联网上搜索可用的帮助
解决方案
在你的架构截图列中是拼写
Doudenum2
在您的查询中,您拼写为
十二指肠2
所以你需要改变
CASE endo.Duodenum2 WHEN
To
CASE endo.Doudenum2 当跨度>
I have this MySQL Command.
SELECT
endo.ReportDate,
endo.ReportNo,
patient.EMRNo,
patient.PName,
patient.Address,
patient.Age,
patient.Sex,
endo.RefUnit,
endo.Ward,
endo.ProvDiag,
endo.Premed,
CASE endo.Larynx WHEN 'Normal' THEN endo.Larynx WHEN 'Findings' THEN CONCAT(endo.Larynx,' : ',endo.LarynxF) END AS Larynx,
CASE endo.Esophagus WHEN 'Normal' THEN endo.Esophagus WHEN 'Findings' THEN CONCAT(endo.Esophagus,' : ',endo.EsophagusF) END AS Esophagus,
CASE endo.Stomach WHEN 'Normal' THEN endo.Stomach WHEN 'Findings' THEN CONCAT(endo.Stomach,' : ',endo.StomachF) END AS Stomach,
CASE endo.Pylorus WHEN 'Normal' THEN endo.Pylorus WHEN 'Findings' THEN CONCAT(endo.Pylorus,' : ',endo.PylorusF) END AS Pylorus,
CASE endo.Duodenum1 WHEN 'Normal' THEN endo.Duodenum1 WHEN 'Findings' THEN CONCAT(endo.Duodenum1,' : ',endo.Duodenum1F) END AS Duodenum1,
CASE endo.Duodenum2 WHEN 'Normal' THEN endo.Duodenum2 WHEN 'Findings' THEN CONCAT(endo.Doudenum2,' : ',endo.Doudenum2F) END AS Doudenum2,
CONCAT(endo.HpTest,', ',endo.HpTestF) AS HpTest,
endo.Biopsy,
endo.Diagnosis,
endo.Advice,
endo.PerformedBy,
endo.SignedBy
FROM
endo
INNER JOIN patient ON patient.EMRNo = endo.EMRNo
and it gives the error
[Err] 1054 - Unknown column 'endo.Duodenum2' in 'field list'
and i have a table like this:
[IMG]http://i65.tinypic.com/qzku95.jpg[/IMG]
I can't seem to find the problem.. any help would be appreciated
What I have tried:
Searching internet for available help
解决方案
In your schema screenshot the column is spelled
Doudenum2
In your query, you are spelling it as
Duodenum2
So you need to change
CASE endo.Duodenum2 WHEN
To
CASE endo.Doudenum2 WHEN
这篇关于Mysql未知列[错误] 1054 - '字段列表'中未知列'endo.duodenum2'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文