SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT FROM information_schema. COLUMNS WHERE TABLE_SCHEMA = '数据库名称'
转载于:https://www.cnblogs.com/shuaiqun/p/9288984.html
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT FROM information_schema. COLUMNS WHERE TABLE_SCHEMA = '数据库名称'
转载于:https://www.cnblogs.com/shuaiqun/p/9288984.html