Collections:
List Table Names with "mysqlshow" Command in MySQL
How To Show Table Names with "mysqlshow" in MySQL?
✍: FYIcenter.com
If you want to show table names with "mysqlshow", you need to specify a database name. The followings tutorial exercise shows you how to get all table names that match a pattern:
If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database:
>cd \mysql\bin >mysqlshow --verbose mysql time% Database: mysql Wildcard: time% +---------------------------+----------+ | Tables | Columns | +---------------------------+----------+ | time_zone | 2 | | time_zone_leap_second | 2 | | time_zone_name | 2 | | time_zone_transition | 3 | | time_zone_transition_type | 5 | +---------------------------+----------+ 5 rows in set.
⇒ What Is "mysqldump" Command in MySQL
⇐ What Is "mysqlshow" Command in MySQL
2018-05-19, 3501🔥, 0💬
Popular Posts:
What Happens to an Arithmetic Operation with Two Different Data Types in SQL Server Transact-SQL? Wh...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...