Shulou(Shulou.com)05/31 Report--

Mysql how to query the data dictionary, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

SELECT a.TABLE_NAME as tableName,b.TABLE_COMMENT as tableComment, a.COLUMN_NAME as columnName, a.COLUMN_COMMENT as columnComment, a.COLUMN_TYPE as columnType, null as length, null as scale A.IS_NULLABLE as isNullable from information_schema.COLUMNS a LEFT JOIN information_schema.TABLES b ON a.TABLE_NAME=b.TABLE_NAME where a. TABLEX SCHEMA has read the above content after reading the hbsmm 'and a.TABLE_NAME in. Have you mastered how to query the data dictionary in Mysql? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.