MySQL Forums
Forum List  »  Stored Procedures

Re: Count Table rows using Stored Procedure
Posted by: A. Aquiles
Date: February 12, 2018 09:13AM

Not interested in controversy, but I'm not sure about the statistical bit.

I've got a table that has not been touched in 2 years (that's why I have migrated it in the first place). So it's not transactional or, if you prefer, does not suffer changes.

So I compare both tables (in 2 separate servers) using SELECT COUNT(*). Both give exactly and precisely same no. of rows (which indicates COUNT(*) does the right thing, counting rows, how could it be statistical?).

However, if you use <information_schema>, tables in both servers show very different -and very inaccurate!- no. of rows. They don't match at all.

I tried to read the link you included but couldn't find the intended reference.

Options: ReplyQuote

Written By
Re: Count Table rows using Stored Procedure
February 12, 2018 09:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.