随笔分类 -  mysql

mysql获取每个表的每个字段的长度
摘要：SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE, ( CASE WHEN DATA_TYPE IN ('tinyint') THEN 1 WHEN DATA_TYPE IN ('smallint') THEN 2 WHEN DATA_T 阅读全文
posted @ 2024-04-17 15:43 Amireux-126 阅读(133) 评论(0) 推荐(0) 编辑
mysql数据库查询单表行长度
摘要：SELECT t.TABLE_NAME, -- t.table_type, SUM( CASE WHEN c.DATA_TYPE = 'tinyint' THEN 1 WHEN c.DATA_TYPE = 'smallint' THEN 2 WHEN c.DATA_TYPE = 'mediumint 阅读全文
posted @ 2024-04-16 15:21 Amireux-126 阅读(45) 评论(0) 推荐(0) 编辑