Collections:
Non-Standard SQL Commands in MySQL
What Are the Non-Standard SQL Commands Supported by "mysql" in 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)
⇒ Getting Help Information from the Server in MySQL
⇐ DML Commands Supported in MySQL
2018-02-08, 3680🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...