MySQL - What is "mysqlshow"?

What is "mysqlshow"?

Mysqlshow is typically used by end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow":

1. "mysqlshow" - Shows all the databases.

2. "mysqlshow databaseName" - Shows all the tables in the specified database.

3. "mysqlshow databaseName tableName" - Shows all the columns in the specified table.

4. "mysqlshow--verbose" - Shows all the databases with extra information.

5. "mysqlshow--verbose my%" - Shows all the databases who's names match the pattern "my%" with extra information.

6. "mysqlshow--verbose mysql time%" - Shows all the tables who's names match the pattern "time%" in "mysql" database with extra information.
MySQL - Concept of "mysqlimport" command-line interface
mysqlimport – It is used by administrators or end users to load data files into tables program tool to load data into tables.
MySQL - Explain the "mysql" command Line options
Explain the mysql command Line options - Following are the most commonly used mysql command line options......
MySQL - Explain few command line arguments in MYSQL
Explain few command line arguments in MYSQL - -D – specifies database to use, -h, --host=name - connects to host......
Post your comment

Related Content

Follow us

▲