Unknown table ‘*’ in information_schema
19-10-24 发现了个问题,语句在mysql数据库中执行正常
SELECT column_name, fieldmean FROM (SELECT
t.column_name, t1.fieldmean
FROM
(SELECT
a.column_name AS column_name
FROM
information_schema.COLUMNS a
WHERE
TABLE_SCHEMA = ‘cloudsheep’
AND table_name = ‘TEMP_BD_DAT_WDD2’
AND column_name <> ‘R_ANIMAL’
AND column_name <> ‘R_ANIMALID’) t
LEFT JOIN T_BREED_FIELDDEF t1 ON t1.fieldname = t.column_name
WHERE
(t1.isebv <> 1 OR t1.isebv IS NULL)
AND t1.fieldmean IS NOT NULL) b
但是程序调用时候报Unknown table ‘*’ in information_schema
经过尝试发现将外层关联去掉直接查询也报错,继续去掉只剩下查询(去掉前面的SELECT column_name, fieldmean FROM),执行成功了。。。暂时不知道啥原因 记录下。。
**