1. 登录mysql
mysql -uusername -ppassword
2. 显示数据库:
show database;
3.使用数据库
use information_schema;
4. 以kb计算,若KB计算,需要sum(DATA_LENGTH/1024);执行sql
select concat(round(sum(DATA_LENGTH),2),'KB') as data from TABLES where table_schema='数据库名称'
1. 登录mysql
mysql -uusername -ppassword
2. 显示数据库:
show database;
3.使用数据库
use information_schema;
4. 以kb计算,若KB计算,需要sum(DATA_LENGTH/1024);执行sql
select concat(round(sum(DATA_LENGTH),2),'KB') as data from TABLES where table_schema='数据库名称'