Table Size

[jamesm87]

Hi.

How do you do a SQL query that will count the size of a number of tables?

Also how can you get it to count the size of all tables begining with a word and anything on the end

      Table

ie ... james_*(Whatever)

Thanks in advance

[LordShryku]

Size in bytes? Or number of records?
Is this going to be all tables in a database? Or only a select few?
What type of DB? (MySQL, PostgreSQL, Oracle, etc)
What version of the DB are you running?

[jamesm87]

Originally posted by LordShryku
Size in bytes? Or number of records?
Is this going to be all tables in a database? Or only a select few?
What type of DB? (MySQL, PostgreSQL, Oracle, etc)
What version of the DB are you running?

Sorry, I forgot. 😃

Size in bytes
Select a few tables with the extension phpbb_
MySQL 4.0.15-standard

Thanks!

James