http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
Searching is usually faster than waiting for the list to respond, too. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Sohail Hasan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, 11 June, 2003 16:33 Subject: Re: tables size in mysql database I got these : | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_ti me | Update_time | Check_time | Create_options | Comment I guess Data_length shows the size in bytes of the table. if it isn't then what is the field for that? Jeremy Zawodny wrote: >On Wed, Jun 11, 2003 at 10:08:47AM +0500, Sohail Hasan wrote: > > >>Hi there, >> >>How can I see per table size of all tables in a particular database. >> >> > >SHOW TABLE STATUS > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
