Free Software Server Environment : MySqlShow

HomePage :: Categories :: PageIndex :: RecentChanges


Search this site: FSSE.INFO is produced by "osde8info" :

MySQL Show


show databases
$ mysqlshow


+--------------------+
|     Databases      |
+--------------------+
| information_schema |
| bbpress            |
| mysql              |
| txp                |
+--------------------+


show tables
$ mysqlshow -i bbpress | cut -c -80


Database: bbpress
+--------------+--------+---------+------------+------+----------------+--------
| Name         | Engine | Version | Row_format | Rows | Avg_row_length | Data_le
+--------------+--------+---------+------------+------+----------------+--------
| bb_forums    | MyISAM | 10      | Dynamic    | 1    | 32             | 32
| bb_posts     | MyISAM | 10      | Dynamic    | 4    | 79             | 316
| bb_tagged    | MyISAM | 10      | Fixed      | 2    | 33             | 66
| bb_tags      | MyISAM | 10      | Dynamic    | 2    | 34             | 68
| bb_topicmeta | MyISAM | 10      | Dynamic    | 0    | 0              | 0
| bb_topics    | MyISAM | 10      | Dynamic    | 2    | 102            | 204
| bb_usermeta  | MyISAM | 10      | Dynamic    | 3    | 58             | 176
| bb_users     | MyISAM | 10      | Dynamic    | 2    | 90             | 180
+--------------+--------+---------+------------+------+----------------+--------



REFERRERS
MySqlUtilities

There are no comments on this page. [Add comment]

Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki
Page was generated in -0.8644 seconds