MySQL. Table size

[trichevio]

SELECT table_name AS table_name, engine, ROUND(data_length/1024/1024,2) AS total_size_mb, table_rows FROM information_schema.tables WHERE table_schema=DATABASE(); //or just table_schema='table_name';
Originally published at blog.trichev.com. You can comment here or there.