Mysql get information on all tables of a database
By admin on Jun 16, 2009 | In MySQL | Send feedback »
The following mysql query allows you to get all table info for a specific db including number of rows, row format, avg_row_length, data length etc.
SHOW TABLE STATUS FROM databasename;
Trackback address for this post
Trackback URL (right click and copy shortcut/link location)
Feedback awaiting moderation
This post has 368 feedbacks awaiting moderation...
Comments are not allowed from anonymous visitors.
| « Parallels Helm not recording bandwidth and space usage | Mysql field in asp generates error: Variable uses an Automation type not supported in VBScript » |