sql语句导出数据库
- 格式:docx
- 大小:126.72 KB
- 文档页数:2
select TABLE_NAME, COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='1010gps' order by TABLE_NAME
-- select TABLE_NAME, COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='1010gps' and table_name = 'dev_info';
-- select * from information_schema.columns where table_schema ='1010gps' and table_name = 'dev_info';
select TABLE_NAME, COLUMN_NAME,COLUMN_TYPE,COLUMN_COMMENT from information_schema.columns where table_schema ='1010gps'
order by TABLE_NAME