MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: count rows in a partition
Posted by: Keith Larson
Date: May 15, 2013 12:52AM

I figured it would be nice to create an example in case others ask this later.
http://anothermysqldba.blogspot.com/2013/05/mysql-count-and-select-from-partition.html

You almost had it though:
SELECT COUNT(*) FROM log_01 PARTITION (p1);

Just trying to help....

http://anothermysqldba.blogspot.com

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


Subject
Written By
Posted
count rows in a partition
Darren White
May 14, 2013 10:46PM
Re: count rows in a partition
Keith Larson
May 15, 2013 12:52AM
Re: count rows in a partition
Rick James
May 15, 2013 08:16PM
Re: count rows in a partition
Darren White
May 15, 2013 09:54PM
Re: count rows in a partition
Rick James
May 16, 2013 08:35AM
Re: count rows in a partition
Darren White
July 30, 2013 08:47AM
Re: count rows in a partition
Rick James
July 30, 2013 08:54PM


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.