查询数据库占用大小MB
SELECT CONCAT(round(sum(data_length/1024/1024),2),' MB') AS data_size FROM information_schema.tables WHERE table_schema='MyDataBase';
查询数据库占用大小 GB
SELECT CONCAT(round(sum(data_length/1024/1024/1024),2),' GB') AS data_size FROM information_schema.tables WHERE table_schema='myDataBase';
查询数据库总体行数
SELECT SUM(TABLE_ROWS) FROM information_schema.TABLES WHERE TABLE_SCHEMA='myDataBase';
【mysql常用数据库操作语句】
最新推荐文章于 2024-08-23 17:37:15 发布