有哪些表:show tables
处于那个数据库:show databases
表结构:1.desc table_name(大写) 2.show columns from TABLENAME;(表名大写)3.show create table TABLENAME;(表名大写)
指定库中各个表的大小:select
table_name, (data_length+index_length)/1024/1024 as total_mb, table_rows from information_schema.tables where table_schema=
'zabbix'
;