使用SQL语句查看MySQL数据库字典
1.问题:mysql 查看某个数据库中所有表的数据量
登录mysql
使用命令:use information_schema;
使用命令:select table_name,table_rows from tables where TABLE_SCHEMA = ‘emphant’ order by table_rows desc;
2.问题:查询库中所有某个表字段信息。
SELECT TABLE_SCHEMA,TABLE_NAME,LOWER(column_name),DATA_TYPE,column_comment FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = ‘MYSQL’ AND LOWER(column_name) = ‘user’;
3.查询注释乱码的字段信息
SELECT TABLE_NAME,column_name,DATA_TYPE,column_comment FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = ‘evshare’ AND column_comment LIKE ‘%?%’;
4.数据字典方法一:
SELECT a.TABLE_SCHEMA as 库名,
a.table_name as 表明,a.COLUMN_NAME as 字段名,
a.column_type as 数据类型, case IFNULL(a.COLUMN_DEFAULT,‘NULL’)
when ‘’ then ‘空字符串’
WHEN ‘NULL’ then ‘NULL’
ELSE a.COLUMN_DEFAULT END as 默认值,
CASE a.is_nullable
WHEN ‘YES’ THEN
‘是’
ELSE
MySQL数据库字典生成工具
最新推荐文章于 2024-04-22 09:52:50 发布