MySQL table size?

[kaits]

How to get the size of MySQL table in bytes?
SHOW TABLE STATUS or something?

a little example would be nice

 

[Matthias Reitinger]

Ex.:

$result = mysql_query("SHOW TABLE STATUS LIKE '$table'");
$row = mysql_fetch_array($result);
$table_size = $row['Data_length'] + $row['Index_length'];

 

[kaits]

thanks