Note that SHOW TABLE STATUS counts for innodb are educated guesses -- innodb has to do a table scan to get the actual count.
On Thu, 14 Oct 2004 10:19:19 -0400, Michael Stassen <[EMAIL PROTECTED]> wrote: > Sujay, > > The output of > > DESCRIBE table_name; > > does not include number of rows. Perhaps you meant > > SHOW TABLE STATUS LIKE 'table_name'; > > or simply > > SHOW TABLE STATUS; > > as Michael suggested, to get output for each and every table. If so, it is > important to note that the row count for InnoDB tables is an approximation, > rather than an accurate count, so it won't help here. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
