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, 2171🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...