Alex, yes, SHOW TABLE STATUS returns only approximate statistics about the row count for Innobase tables. These statistics are used in the SQL optimization. >From section 8.7 in the MySQL manual: ...........<snip>............ SHOW TABLE STATUS FROM TEST LIKE 'CUSTOMER' if you have created a table of name CUSTOMER in a database you have named TEST. Note that the statistics SHOW gives about Innobase tables are only approximate: they are used in SQL optimization. Table and index reserved sizes in bytes are accurate, though. ...........<snip>............. Regards, Heikki >Bonjour, > I have a table with 111619 rows in it. > "show table status" and "select count(*)" don't return the same > number of rows. > Is this know ? > Regards, > Alex. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
