mysql 查询表的指定列名

SELECT COLUMN_NAME FROM information_schema.`COLUMNS` WHERE `TABLE_NAME` = ‘table_name’ AND `TABLE_SCHEMA` = ‘db_name’ LIMIT 0, 1000

发表评论