Table sizes in K

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Gen-ik
DevNet Resident
Posts: 1059
Joined: Mon Aug 12, 2002 7:08 pm
Location: London. UK.

Table sizes in K

Post by Gen-ik »

I'm trying to find out how I can get the overall size of a Table in a MySQL Database.

I know that by running the mysql_query("DESCRIBE $table") you will get the following info for the $table..

Field Name
Type
Is Null?
Key
Default
Extra

..but I can't seem to find a way to get the size (total size of contents).

Does anyone who how to do this?

Thanks.
Post Reply