navicate 导出数据字典。先查询,再导出。查询sql语句如下:
select TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT
from information_schema.`COLUMNS`
where TABLE_SCHEMA='activity' and TABLE_NAME='member'
navicate 导出数据字典。先查询,再导出。查询sql语句如下:
select TABLE_NAME, COLUMN_NAME, COLUMN_TYPE, COLUMN_COMMENT
from information_schema.`COLUMNS`
where TABLE_SCHEMA='activity' and TABLE_NAME='member'
转载于:https://my.oschina.net/Sandyguoguo/blog/740012