Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Show Table Names with "mysqlshow"
How To Show Table Names with "mysqlshow"? - MySQL FAQs - Administrator Tools for Managing MySQL Server
✍: 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.
2007-05-11, 4655👍, 0💬
Popular Posts:
Where Do You Download JUnit? Where do I download JUnit? I don't think anyone will ask this question ...
What is a delegate ? Delegate is a class that can hold a reference to a method or a function. Delega...
What Is the Data Pump Import Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump...
. How can a servlet refresh automatically if some new data has entered the database? You can use a c...
How To Create an Array in PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL If you want create an ar...