做个笔记
SELECT table_schema "database_name", TABLE_NAME AS 'table_name',
( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
WHERE table_schema = 'database_name';
命令建索引:
create index index_name on table_name (column_name);