Re: Rows from STATUS differs from SELECT COUNT(*)

On Thu, May 30, 2002 at 06:18:46PM +0200, Iago Sineiro wrote: > Hi all. > > I have two questions about InnoDB table type. > > 1) I execute command SHOW TABLE STATUS for a table and the value for column > Rows is different from the result of SELECT COUNT(*) for that table. > > mysql> SHOW TABLE

Rows from STATUS differs from SELECT COUNT(*)

Hi all. I have two questions about InnoDB table type. 1) I execute command SHOW TABLE STATUS for a table and the value for column Rows is different from the result of SELECT COUNT(*) for that table. mysql> SHOW TABLE STATUS LIKE 'ALBARANCL'; +---++++-