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, 1493🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...