Unknown table '*' in information_schema

最新推荐文章于 2023-12-20 16:47:38 发布

小白啊~

最新推荐文章于 2023-12-20 16:47:38 发布

阅读量9k

点赞数

文章标签： mysql语句执行报错

本文链接：https://blog.csdn.net/qq_23976837/article/details/102724369

版权

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），执行成功了。。。暂时不知道啥原因记录下。。
**