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, 4814👍, 0💬
Popular Posts:
.NET INTERVIEW QUESTIONS - Did VB6 support multi-threading ? While VB6 supports multiple single-thre...
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configu...
How To Enter Microseconds in SQL Statements? - MySQL FAQs - Introduction to SQL Date and Time Handli...
What will be printed as the result of the operation below: main() { char *ptr = " Cisco Systems"; *p...
Example of using Regular Expressions for syntax checking in JavaScript ... var re = new RegExp("^(&a...