MySQL - Explain some of the non-standard SQL commands in MySQL

Explain some of the non-standard SQL commands in MySQL.

There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands:

1. "SHOW infoName" - Shows basic information of based on the specified information name.

2. "SHOW infoName" - Shows basic information of based on the specified information name.

3. "SET ..." - Sets new values to server or connection session variables.

4. "GRANT ..." - Grants access privileges to users.

5. "REVOKE ..." - Revokes access privileges from users.

6. "CHECK TABLE tableName" - Checks the specified table for errors.

7. "ANALYZE TABLE tableName" - Analyzes the specified table.

8. "REPAIR TABLE tableName" - Repairs the specified table.

9. "BACKUP TABLE tableName" - Backs up the specified table.

10. "RESTORE TABLE tableName" - Restores the specified table.

11. "USE databaseName" - Uses the specified database as the current database.

12. "HELP topicName" - Returns help information on the specified topic.
MySQL - Differentiate between BINARY and VARBINARY in MySQL
Differentiate between BINARY and VARBINARY in MySQL - BINARY and VARBINARY have the same nature of differences like CHAR and VARCHAR......
MySQL - Differentiate between CHAR and VARCHAR in MySQL
Differentiate between CHAR and VARCHAR in MySQL - CHAR stores the data or values in fixed length format. If the size of the string is smaller than the specified length.......
MySQL - Differentiate between CHAR and NCHAR.
Differentiate between CHAR and NCHAR - CHAR is commonly referred to as character while NCHAR is referred to as NATIONAL CHARACTER......
Post your comment

Related Content

Follow us

▲