1.查看全部
select *
from information_schema.columns
where table_name="表名"
and table_schema="数据库名";
2、以逗号连接,直接可用
select group_concat(COLUMN_NAME)
from information_schema.columns
where table_name="表名"
and table_schema="数据库名";
1.查看全部
select *
from information_schema.columns
where table_name="表名"
and table_schema="数据库名";
2、以逗号连接,直接可用
select group_concat(COLUMN_NAME)
from information_schema.columns
where table_name="表名"
and table_schema="数据库名";