mysql 查询表 的所有字段名称

select COLUMN_NAME from information_schema.COLUMNS where table_name = 'your_table_name' and table_schema = 'your_db_name'; 
原文地址:https://www.cnblogs.com/anxbb/p/10002113.html