MySQL Forums
Forum List  »  Newbie

counting tables?
Posted by: James Leighton
Date: April 29, 2005 09:44AM

i've been through this and a few forums and the docs, and don't seem to have come across a way of counting how many tables are in a database.

specifically while using a like 'sometable%' would be useful for me

is this possible?

if there is not a command for this, i see that

mysql>show tables like 'sometable%';

returns a table count at the bottom, maybe i can retrieve that somehow?

James Leighton

Options: ReplyQuote


Subject
Written By
Posted
counting tables?
April 29, 2005 09:44AM
April 29, 2005 11:25AM
April 29, 2005 04:09PM
April 29, 2005 04:48PM


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.