create view PARTITIONS as
select (`cat`.`name` collate utf8mb3_tolower_ci) AS `TABLE_CATALOG`,
(`sch`.`name` collate utf8mb3_tolower_ci) AS `TABLE_SCHEMA`,
`tbl`.`name` AS `TABLE_NAME`,
`part`.`name` AS `PARTITION_NAME`,
`sub_part`.`name` AS `SUBPARTITION_NAME`,
(`part`.`number` + 1) AS `PARTITION_ORDINAL_POSITION`,
(`sub_part`.`number` + 1) AS `SUBPARTITION_ORDINAL_POSITION`,
(case `tbl`.`partition_type`
when 'HASH' then 'HASH'
when 'RANGE' then 'RANGE'
when 'LIST' then 'LIST'
when 'AUTO' then 'AUTO'
when 'KEY_51' then 'KEY'
when 'KEY_55' then 'KEY'
when 'LINEAR_KEY_51' then 'LINEAR KEY'
when 'LINEAR_KEY_55' then 'LINEAR KEY'
when 'LINEAR_HASH' then 'LINEAR HASH'
when 'RANGE_COLUMNS' then 'RANGE COLUMNS'
when 'LIST_COLUMNS' then 'LIST COLUMNS'
else NULL end) AS `PARTITION_METHOD`,
(case `tbl`.`subpartition_type`
when 'HASH' then 'HASH'
when 'RANGE' then 'RANGE'
when 'LIST' then 'LIST'
when 'AUTO' then 'AUTO'
when 'KEY_51' then 'KEY'
when 'KEY_55' then 'KEY'
when 'LINEAR_KEY_51' then 'LINEAR KEY'
when 'LINEAR_KEY_55' then 'LINEAR KEY'
when 'LINEAR_HASH' then 'LINEAR HASH'
when 'RANGE_COLUMNS' then 'RANGE COLUMNS'
when 'LIST_COLUMNS' then 'LIST COLUMNS'
else NULL end) AS `SUBPARTITION_METHOD`,
`tbl`.`partition_expression_utf8` AS `PARTITION_EXPRESSION`,
`tbl`.`subpartition_expression_utf8` AS `SUBPARTITION_EXPRESSION`,
`part`.`description_utf8` AS `PARTITION_DESCRIPTION`,
internal_table_rows(`sch`.`name`, `tbl`.`name`, if((`tbl`.`partition_type` is null), `tbl`.`engine`, ''),
`tbl`.`se_private_id`, (`tbl`.`hidden` <> 'Visible'), if((`sub_part`.`name` is null),
if((`part`.`name` is null),
`tbl`.`se_private_data`,
`part_ts`.`se_private_data`),
`sub_part_ts`.`se_private_data`), 0,
0,
ifnull(`sub_part`.`name`, `part`.`name`)) AS `TABLE_ROWS`,
internal_avg_row_length(`sch`.`name`, `tbl`.`name`, if((`tbl`.`partition_type` is null), `tbl`.`engine`, ''),
`tbl`.`se_private_id`, (`tbl`.`hidden` <> 'Visible'), if((`sub_part`.`name` is null),
if((`part`.`name` is null),
`tbl`.`se_private_data`,
`part_ts`.`se_private_data`),
`sub_part_ts`.`se_private_data`),
0, 0,
ifnull(`sub_part`.`name`, `part`.`name`)) AS `AVG_ROW_LENGTH`,
internal_data_length(`sch`.`name`, `tbl`.`name`, if((`tbl`.`partition_type` is null), `tbl`.`engine`, ''),
`tbl`.`se_private_id`, (`tbl`.`hidden` <> 'Visible'), if((`sub_part`.`name` is null),
if((`part`.`name` is null),
`tbl`.`se_private_data`,
`part_ts`.`se_private_data`),
`sub_part_ts`.`se_private_data`),
0, 0,
ifnull(`sub_part`.`name`, `part`.`name`)) AS `DATA_LENGTH`,
internal_max_data_length(`sch`.`name`, `tbl`.`name`, if((`tbl`.`partition_type` is null), `tbl`.`engine`, ''),
`tbl`.`se_private_id`, (`tbl`.`hidden` <> 'Visible'), if((`sub_part`.`name` is null),
if((`part`.`name` is null),
`tbl`.`se_private_data`,
`part_ts`.`se_private_data`),
`sub_part_ts`.`se_private_data`),
0, 0,
ifnull(`sub_part`.`name`, `part`.`name`)) AS `MAX_DATA_LENGTH`,
internal_index_length(`sch`.`name`, `tbl`.`name`, if((`tbl`.`partition_type` is null), `tbl`.`engine`, ''),
`tbl`.`se_private_id`, (`tbl`.`hidden` <> 'Visible'), if((`sub_part`.`name` is null),
if((`part`.`name` is null),
`tbl`.`se_private_data`,
`part_ts`.`se_private_data`),
`sub_part_ts`.`se_private_data`),
0, 0,
ifnull(`sub_part`.`name`, `part`.`name`)) AS `INDEX_LENGTH`,
internal_data_free(`sch`.`name`, `tbl`.`name`, if((`tbl`.`partition_type` is null), `tbl`.`engine`, ''),
`tbl`.`se_private_id`, (`tbl`.`hidden` <> 'Visible'), if((`sub_part`.`name` is null),
if((`part`.`name` is null),
`tbl`.`se_private_data`,
`part_ts`.`se_private_data`),
`sub_part_ts`.`se_private_data`), 0,
0,
ifnull(`sub_part`.`name`, `part`.`name`)) AS `DATA_FREE`,
`tbl`.`created`
mybatis系列教程博客的源码-东离与糖宝
需积分: 0 8 浏览量
2023-05-18
15:39:12
上传
评论
收藏 360KB RAR 举报
DL_mb.rar （86个子文件） 
view 
TABLE_CONSTRAINTS_EXTENSIONS.jsEY2g.meta 106B TABLES_EXTENSIONS.LnoHsA.sql 640B APPLICABLE_ROLES._QVJ6A.sql 9KB ST_SPATIAL_REFERENCE_SYSTEMS.99eQsg.sql 640B ADMINISTRABLE_ROLE_AUTHORIZATIONS.dS-h6w.meta 109B STATISTICS.I51GFw.sql 4KB INNODB_FOREIGN.GWT7Cg.meta 95B CHECK_CONSTRAINTS.P2mJvg.meta 94B KEY_COLUMN_USAGE.WH0DEQ.sql 5KB ST_SPATIAL_REFERENCE_SYSTEMS.99eQsg.meta 104B STATISTICS.I51GFw.meta 91B COLUMNS_EXTENSIONS.1sHqLw.meta 98B COLUMNS_EXTENSIONS.1sHqLw.sql 1015B USER_ATTRIBUTES.S0rwRg.sql 411B ADMINISTRABLE_ROLE_AUTHORIZATIONS.dS-h6w.sql 866B TABLES.ZTIKkw.meta 85B VIEW_TABLE_USAGE.FvP5Cw.meta 92B ROLE_ROUTINE_GRANTS.u-H58Q.sql 8KB INNODB_FIELDS.tBoZYw.meta 90B TRIGGERS.u1E9iA.meta 87B CHECK_CONSTRAINTS.P2mJvg.sql 688B VIEW_ROUTINE_USAGE.DMqSZQ.meta 97B TRIGGERS.u1E9iA.sql 2KB PARTITIONS.yTZTHw.meta 94B CHARACTER_SETS.xzMQlQ.sql 343B INNODB_DATAFILES.EiepxQ.meta 92B REFERENTIAL_CONSTRAINTS.wAQnHQ.sql 1KB ROLE_TABLE_GRANTS.sRF-9Q.meta 97B KEYWORDS.qo_UTQ.meta 91B INNODB_TABLESPACES_BRIEF.m63ovA.meta 102B TABLE_CONSTRAINTS_EXTENSIONS.jsEY2g.sql 832B INNODB_FOREIGN_COLS.WaOGbg.meta 95B SCHEMATA_EXTENSIONS.JRHaJQ.sql 382B ST_UNITS_OF_MEASURE.5P_Kqg.meta 99B EVENTS.GdWaeg.sql 3KB ST_GEOMETRY_COLUMNS.DnfL_g.sql 901B FILES.V8L8Aw.meta 84B RESOURCE_GROUPS.JQut-Q.sql 495B PARAMETERS.6q1BOA.sql 4KB ST_UNITS_OF_MEASURE.5P_Kqg.sql 3KB VIEWS.TiLeBA.meta 86B ROUTINES.L6j6Lg.sql 7KB VIEW_TABLE_USAGE.FvP5Cw.sql 946B ROUTINES.L6j6Lg.meta 87B INNODB_TABLESPACES_BRIEF.m63ovA.sql 940B COLLATIONS.Ct42rw.sql 1KB SCHEMATA.zk8QBQ.sql 791B EVENTS.GdWaeg.meta 86B RESOURCE_GROUPS.JQut-Q.meta 92B PARAMETERS.6q1BOA.meta 91B INNODB_FOREIGN_COLS.WaOGbg.sql 942B INNODB_DATAFILES.EiepxQ.sql 428B VIEWS.TiLeBA.sql 2KB SCHEMATA.zk8QBQ.meta 86B ENABLED_ROLES._3NgIg.meta 94B TABLESPACES_EXTENSIONS.eOmZZA.sql 165B COLUMN_STATISTICS.rFnu0Q.sql 447B KEY_COLUMN_USAGE.WH0DEQ.meta 97B ST_GEOMETRY_COLUMNS.DnfL_g.meta 95B TABLES_EXTENSIONS.LnoHsA.meta 94B INNODB_FIELDS.tBoZYw.sql 687B INNODB_FOREIGN.GWT7Cg.sql 1KB TABLES.ZTIKkw.sql 7KB TABLE_CONSTRAINTS.Bcf7Og.sql 3KB ROLE_ROUTINE_GRANTS.u-H58Q.meta 100B PARTITIONS.yTZTHw.sql 12KB VIEW_ROUTINE_USAGE.DMqSZQ.sql 1KB COLUMN_STATISTICS.rFnu0Q.meta 93B FILES.V8L8Aw.sql 7KB APPLICABLE_ROLES._QVJ6A.meta 97B ROLE_COLUMN_GRANTS.1wO1Vg.meta 98B COLUMNS.vSNnYw.sql 6KB SCHEMATA_EXTENSIONS.JRHaJQ.meta 97B KEYWORDS.qo_UTQ.sql 12KB COLLATION_CHARACTER_SET_APPLICABILITY.3EsKUg.meta 115B ROLE_COLUMN_GRANTS.1wO1Vg.sql 8KB ENABLED_ROLES._3NgIg.sql 1KB COLLATIONS.Ct42rw.meta 89B USER_ATTRIBUTES.S0rwRg.meta 92B REFERENTIAL_CONSTRAINTS.wAQnHQ.meta 104B TABLESPACES_EXTENSIONS.eOmZZA.meta 100B TABLE_CONSTRAINTS.Bcf7Og.meta 97B COLLATION_CHARACTER_SET_APPLICABILITY.3EsKUg.sql 245B COLUMNS.vSNnYw.meta 87B CHARACTER_SETS.xzMQlQ.meta 92B ROLE_TABLE_GRANTS.sRF-9Q.sql 8KB资源评论
