select group_concat(COLUMN_NAME) from information_schema.COLUMNS where table_name = '表名' and table_schema = '库名';
sql查询表的所有字段
最新推荐文章于 2023-03-08 17:11:28 发布
select group_concat(COLUMN_NAME) from information_schema.COLUMNS where table_name = '表名' and table_schema = '库名';