SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'db_name' and table_name = 'tbl_name'
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'db_name' and table_name = 'tbl_name'
转载于:https://my.oschina.net/flowf/blog/32345