查询表的列名

SELECT COLUMN_NAME FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = 'xxxxx' AND TABLE_NAME = 'xxxx';

原文地址:https://www.cnblogs.com/howmanyk/p/14523779.html