首页SELECT COLUMN_NAME AS 字段名称, COLUMN_TYPE AS 数据类型, IF ( COLUMN_KEY = 'PRI', 'Y', 'N' ) AS 主键, COLUMN_COMMENT AS 备注 FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = 'ODSSHARE' AND table_name = 'A_TEMPCY2'哪里有问题

SELECT COLUMN_NAME AS 字段名称, COLUMN_TYPE AS 数据类型, IF ( COLUMN_KEY = 'PRI', 'Y', 'N' ) AS 主键, COLUMN_COMMENT AS 备注 FROM INFORMATION_SCHEMA.COLUMNS WHERE table_schema = 'ODSSHARE' AND table_name = 'A_TEMPCY2'哪里有问题

时间: 2024-01-10 15:04:20 浏览: 70

SELECT column_name(s)

SELECT column_name(s) FROM table_name WHERE column_name LIKE patternSELECT column_name(s) FROM table_name WHERE column_name LIKE pattern

根据您提供的查询语句，我看不出有明显的错误。这个查询语句的目的是从 `INFORMATION_SCHEMA.COLUMNS` 表中检索 `ODSSHARE` 数据库中 `A_TEMPCY2` 表的列信息，并使用别名对结果进行重命名。如果您遇到了问题，请提供更具体的错误信息或问题描述，这样我可以更好地帮助您解决问题。

阅读全文