当前位置：网站首页>Use Navicat Premium to export database table structure information to Excel

Use Navicat Premium to export database table structure information to Excel

2022-08-11 04:26:00 【A rookie is a god】

Execute sql

SELECTCOLUMN_NAME column name,COLUMN_TYPE data type,DATA_TYPE field type,CHARACTER_MAXIMUM_LENGTH length,IS_NULLABLE is empty,COLUMN_DEFAULT default value,COLUMN_COMMENT CommentsFROMINFORMATION_SCHEMA.COLUMNSWHERE-- Fill in the name of the database to export the table structuretable_schema = 'database'-- table name, fill in the name of the table to be exported-- If not written, query data in all tables by defaultAND table_name = 'tablename';

Note:

database: fill in the database name;tablename: Fill in the table to be exported to excel.

Execution result

Copy result

Click the result, ctrl+a

Copy into excel

Open a blank Excel document, Ctrl+V

原网站

版权声明
本文为[A rookie is a god]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/223/202208110359594153.html

边栏推荐

猜你喜欢

随机推荐