mysql查询库中的所有表名和表其他信息

时间:2023/6/20 14:44:39 赞:0 踩:0 阅:243 标签:mysql

SELECT * FROM information_schema.tables
WHERE table_schema='workticketdb'
ORDER BY table_rows DESC;

 

workticketdb是表名

执行结果如下:

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE AUTO_INCREMENT CREATE_TIME UPDATE_TIME CHECK_TIME TABLE_COLLATION CHECKSUM CREATE_OPTIONS TABLE_COMMENT
------------- ------------ ------------------------ ---------- ------ ------- ---------- ---------- -------------- ----------- --------------- ------------ --------- -------------- ------------------- ------------------- ---------- ----------------- -------- -------------- --------------------------
def workticketdb dict_data BASE TABLE InnoDB 10 Dynamic 29 564 16384 0 65536 0 43 2023-05-06 08:50:11 (NULL) (NULL) utf8_general_ci (NULL) 字典数据表
def workticketdb dict_type BASE TABLE InnoDB 10 Dynamic 7 2340 16384 0 16384 0 8 2022-12-27 11:34:02 (NULL) (NULL) utf8_general_ci (NULL) 字典类型表
def workticketdb feedback BASE TABLE InnoDB 10 Dynamic 0 0 16384 0 16384 0 2 2023-03-13 14:17:54 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb funmenu BASE TABLE InnoDB 10 Dynamic 64 256 16384 0 16384 0 (NULL) 2023-03-13 14:18:21 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb jsa_device_risk_gather BASE TABLE InnoDB 10 Dynamic 49 1671 81920 0 0 0 51 2023-04-17 09:16:52 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb jsa_device_risk_level BASE TABLE InnoDB 10 Dynamic 49 1337 65536 0 0 0 51 2023-04-17 10:02:37 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb jsa_device_risk_work BASE TABLE InnoDB 10 Dynamic 49 334 16384 0 0 0 55 2023-04-17 10:28:23 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb jsa_work BASE TABLE InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2023-01-31 08:29:56 (NULL) (NULL) utf8_general_ci (NULL) jsa工作安全分析
def workticketdb jsa_work_flow BASE TABLE InnoDB 10 Dynamic 0 0 16384 0 0 0 1 2023-01-13 15:29:30 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb jsa_work_risk BASE TABLE InnoDB 10 Dynamic 49 2340 114688 0 0 0 201 2023-04-19 09:39:30 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb jsa_work_risk_level BASE TABLE InnoDB 10 Dynamic 49 1337 65536 0 0 0 101 2023-04-17 11:06:35 (NULL) (NULL) utf8_general_ci (NULL)
def workticketdb pk_em_card BASE TABLE InnoDB 10 Dynamic 52 315 16384 0 0 0 121 2023-05-17 11:33:33 (NULL) (NULL) utf8_general_ci (NULL) 应急处置卡

评论一下

发表评论

注册用户登录后才能发表评论,请登录注册