What Are The Non-Standard SQL Commands Supported By "mysql"

What Are The Non-Standard SQL Commands Supported By "mysql"


  • 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.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.