Mysql 获取表的所有字段
程序员文章站
2023-12-24 17:21:03
...
Mysql 获取表的所有字段
select COLUMN_NAME from information_schema.COLUMNS where table_name = 'your_table_name'; select COLUMN_NAME from information_schema.COLUMNS where table_name = 'your_table_name' and table_schema = 'your_db_name';
取出所有字段,用一行显示(中间用英文逗号隔开)
select group_concat(COLUMN_NAME SEPARATOR ',') from information_schema.COLUMNS where table_name = 'tableName';