Re: Show table status query

2004-05-18 Thread Stefan Hinz
Daniel Kasak wrote: Andrew Barnes wrote: When I run the SHOW TABLE STATUS query against a database with 4 tables, 3 of the tables come have the correct row count, but 1 table changes the No of rows every time I run the query. The correct row count for this table is 313, but the query returns

Re: Show table status query

2004-05-17 Thread Daniel Kasak
Andrew Barnes wrote: Hi When I run the SHOW TABLE STATUS query against a database with 4 tables, 3 of the tables come have the correct row count, but 1 table changes the No of rows every time I run the query. The correct row count for this table is 313, but the query returns anywhere from 97 to