MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Exact table count for all tables in a schema.
Posted by: sreekanth pm
Date: September 16, 2019 11:15PM

Hi Peter,

The query which you have provided gives only the estimated count.Is there any way to get the actual row count for all tables. Instead of selecting count(*) for each table.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Exact table count for all tables in a schema.
2258
sreekanth pm
September 13, 2019 01:53AM
Re: Exact table count for all tables in a schema.
1055
Peter Brawley
September 13, 2019 09:43AM
Re: Exact table count for all tables in a schema.
975
sreekanth pm
September 16, 2019 11:15PM
Re: Exact table count for all tables in a schema.
714
Peter Brawley
September 17, 2019 10:07AM
Re: Exact table count for all tables in a schema.
797
sreekanth pm
September 19, 2019 12:24AM
Re: Exact table count for all tables in a schema.
754
Peter Brawley
September 19, 2019 09:38AM
Re: Exact table count for all tables in a schema.
814
sreekanth pm
September 20, 2019 04:04AM
Re: Exact table count for all tables in a schema.
641
Peter Brawley
September 20, 2019 09:50AM
Re: Exact table count for all tables in a schema.
1006
sreekanth pm
September 20, 2019 10:03AM
Re: Exact table count for all tables in a schema.
1064
Peter Brawley
September 20, 2019 12:45PM
Re: Exact table count for all tables in a schema.
705
sreekanth pm
September 22, 2019 11:51PM
Re: Exact table count for all tables in a schema.
919
Peter Brawley
September 23, 2019 10:21AM
Re: Exact table count for all tables in a schema.
770
sreekanth pm
September 24, 2019 10:45PM
Re: Exact table count for all tables in a schema.
736
Peter Brawley
September 25, 2019 11:01AM


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.