Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What Are the Non-Standard SQL Commands Supported by “mysql”?

April 26, 2017commands content MySQL non-standard page sql supported

0

Posted

What Are the Non-Standard SQL Commands Supported by “mysql”?

1 Answer

0

Posted

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.