sql,SELECT table_name, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS 'Size (MB)',FROM information_schema.TABLES,WHERE table_schema = 'your_database_name';,
`,,将
your_database_name`替换为你实际的数据库名称。这条语句会返回每个表的名称和大小(以MB为单位)。sql,SELECT table_name, ROUND(((data_length + index_length) / 1024 / 1024), 2) AS 'Size (MB)',FROM information_schema.TABLES,WHERE table_schema = 'your_database_name';,
`,,将
your_database_name`替换为你实际的数据库名称。这条语句会返回每个表的名称和大小(以MB为单位)。Powered By Z-BlogPHP 1.7.3