一、mysql
1、查询某个库中某个表的所以列名。
SELECT COLUMN_NAME as cols FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'mydb' AND TABLE_NAME = 'employee'
2、查询某个库中某个表的所以列名,并以逗号分隔输出为一行。
select
group_concat(column_name separator ',') as cols
from information_schema.columns
where table_schema = 'mydb' and table_name = 'employee'
二、Oracle
1、查询某个表的所以列名。(注意:表名要大写)
SELECT
T.COLUMN_NAME
FROM USER_TAB_COLUMNS T
WHERE T.TABLE_NAME = 'G_MG_MESSAGE_GROUP'
2、查询某个表的所以列名,并以逗号分隔输出为一行。
SELECT
wm_concat(T.COLUMN_NAME) as cols
FROM USER_TAB_COLUMNS T
WHERE T.TABLE_NAME = 'G_MG_MESSAGE_GROUP'
完成。