What Are The Non-Standard SQL Commands Supported By "mysql"
Posted by Sundar
29 Dec, 2011
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.
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.
Comments Received:
Please give your suggestions and feedback: