SELECT
CONCAT( 't.', COLUMN_NAME, ',' )
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'schoolmanage'
AND TABLE_NAME = 'dt_article_category';
说明:
schoolmanage:代表数据库名;
dt_article_category:代表表名;
以上语句执行结果如下:
SELECT
CONCAT( 't.', COLUMN_NAME, ',' )
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'schoolmanage'
AND TABLE_NAME = 'dt_article_category';
说明:
schoolmanage:代表数据库名;
dt_article_category:代表表名;
以上语句执行结果如下: