Answers

Question and Answer:

  Home  MySQL Programming

⟩ What Are the Non-Standard SQL Commands Supported by "mysql"?

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

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

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

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

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

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

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

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

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

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

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

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

► "HELP topicName" - Returns help information on the specified topic.

 161 views

More Questions for you: