mysql获取表的列名

DESC test4

SHOW COLUMNS FROM test4

SELECT COLUMN_NAME  FROM information_schema.columns WHERE table_name='test4'

原文地址:https://www.cnblogs.com/linmob/p/15651538.html