Additions:
mysql show commands
show databases
show tables
ShowGrants
show databases
show tables
ShowGrants
Additions:
==alter==
MySqlAlter
MySqlAlter
Additions:
==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
+--------------+--------+---------+------------+------+----------------+--------
Deletions:
show status
==MySQL show process list==
show processlist
==MySQL show variables==
show variables
==MySQL show databases==
show databases
==MySQL show create table==
show create table mytable
