Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to export a data dictionary query in sql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

USE information_schema SELECT C.TABLE_NAME AS 'table name', T.TABLE_COMMENT AS 'table name', C.COLUMN_NAME AS 'field name', C.COLUMN_COMMENT AS 'field name', C.COLUMN_TYPE AS 'data type' C.EXTRA AS 'primary key' FROM COLUMNS CINNER JOIN TABLES T ON C.TABLE_SCHEMA = T.TABLE_SCHEMAAND C.TABLE_NAME = T.TABLE_NAMEWHERE T.TABLE_SCHEMA = 'db' and T.TABLENAME dictionary query' about how to export data dictionary query in sql is here. Hope that the above content can be helpful to you, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.