mysql 操作

统计字段

如果需要写word文档，统计表信息

select `COLUMN_NAME`,  data_type, 
case when character_maximum_length is not null then character_maximum_length when datetime_precision = 0 then 1 when numeric_scale > 0 then numeric_precision else numeric_precision + 1 end as width,
(case when IS_NULLABLE = 'YES' then 'Y' else 'N' end) as can_null, 
COLUMN_KEY, COLUMN_COMMENT  
from information_schema.`COLUMNS` 
where TABLE_SCHEMA = 'xfuzz' and table_name = 'engine_basic_info';

创建用户，并授权查询权限

CREATE USER 'test'@'%' IDENTIFIED BY '123456';
grant select on *.* to 'test'@'%' identified by '123456';

统计表大小

select CONCAT(ROUND(SUM(DATA_LENGTH/1024/1024),2),'MB') dbsize 
from information_schema.tables
where table_schema='xfuzz' and table_name not in('task_test_case');