mysqlshowmysqlshow lists databases, tables within a database, or information about columns or indexes within a table. It acts as a command-line interface to the SHOW SQL statement. Usagemysqlshow [options] [db_name [tbl_name [col_name]]] If no database name is specified, mysqlshow lists all databases on the server host. If a database name but no table name is specified, all tables in the database are listed. If database and table names are specified, but no column name is specified, it lists the columns in the table. If all the names are specified, mysqlshow shows information about the given column. The final argument may contain the '%' and '_' SQL wildcard characters, which are treated the same way as for the LIKE operator. Output is limited to values that match the wildcards. If the final argument contains the '*' or '?' shell wildcard characters, they are treated as '%' and '_', respectively. Standard Options Supported by mysqlshow--character-sets-dir --host --shared-memory-base-name --compress --password --socket --debug --pipe --user --default-character-set --port --verbose --help --protocol --version mysqlshow also supports the standard SSL options. --default-character-set was introduced in MySQL 4.1.1. Options Specific to mysqlshow
|