PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.3Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be executed to duplicate the privilege assignments. Note To display nonprivilege information for ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. The exact list of privileges depends on the version of your server. row *************************** Privilege: Alter Context: Tables Comment: To ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/5.7/en/show-relaylog-events.html
SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a replica. If you do not specify 'log_name', the first relay log is displayed. The ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given database. You can also get this list using the mysqlshow db_name command. The LIKE clause, if present, indicates which ...
https://dev.mysql.com/doc/refman/5.7/en/shutdown.html
SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command or the mysql_shutdown() C API function. A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
InnoDB performs a bulk load instead of inserting one index record at a time when creating or rebuilding indexes. This method of index creation is also known as a sorted index build. In the first phase, the clustered index is scanned, and index ...
https://dev.mysql.com/doc/refman/5.7/en/sql-statements.html
This chapter describes the syntax for the SQL statements supported by MySQL.
https://dev.mysql.com/doc/refman/5.7/en/statement-labels.html
[begin_label:] BEGIN [statement_list] END [end_label] [begin_label:] LOOP statement_list END LOOP [end_label] [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] [begin_label:] WHILE search_condition DO statement_list ...