MySQL取得一个表的列名方法为:
DESCRIBE TableName
缩写为: DESC TableName
SHOW COLUMNS FROM TableName select COLUMN_NAME from information_schema.columns where table_name='TableName' 也可以实现相同的功能
MySQL取得一个表的列名方法为:
DESCRIBE TableName
缩写为: DESC TableName
SHOW COLUMNS FROM TableName select COLUMN_NAME from information_schema.columns where table_name='TableName' 也可以实现相同的功能