How can get size of table in PhpMyAdmin ?

Question

i going to get size of the table in my database like this code for get table count :

SELECT COUNT(*) FROM "TABLE_NAME"

and use for set value of text box in page ...

Answer 1

SELECT TABLE_NAME, table_rows, data_lenght, index_lenght,
round(((data_lenght + index_lenght) / 1024 / 1024), 2) "Size_MB"
FROM information_schema.TABLES WHERE table_schema = "*****";

***** = Your database name .

Just this ...