select COLUMN_NAME from INFORMATION_SCHEMA.Columns where table_name=‘表名称‘ and table_schema=‘数据库名称‘;
mysql 查询每张表中所有的字段名
原文:https://www.cnblogs.com/hany-postq473111315/p/15202618.html