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:
What Are the Non-Standard SQL Commands Supported by "mysql"
What Are the Non-Standard SQL Commands Supported by "mysql"? - MySQL FAQs - Command-Line End User Interface mysql
✍: FYIcenter.com
There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands:
Here is a tutorial exercise of how to use SHOW, USE and ANALYZE commands in "mysql":
>cd \mysql\bin >mysql -u root mysql> USE test; Database changed mysql> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | articles | | links | +----------------+ 2 rows in set (0.00 sec) mysql> ANALYZE TABLE links; +----------+-------+--------+---------------------------+ |Table |Op |Msg_type|Msg_text | +----------+-------+--------+---------------------------+ |test.links|analyze|status |Table is already up to date| +----------+-------+--------+---------------------------+ 1 row in set (0.14 sec)
2007-05-10, 4771👍, 0💬
Popular Posts:
How Oracle Handles Dead Locks? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle se...
How To Avoid the Undefined Index Error? - PHP Script Tips - Processing Web Forms If you don't want y...
What is difference between Association, Aggregation and Inheritance relationships? In object oriente...
How can you determine the size of an allocated portion of memory? You can't, really. free() can , bu...
What Tools to Use to View HTML Documents? The basic tool you need to view HTML documents is any Web ...