PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +------------------+---------------------+ | VERSION() | sys.version_minor() | +------------------+---------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +------------------+---------------------+ | VERSION() | sys.version_patch() | +------------------+---------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-metadata.html
To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/view-metadata.html
To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.
https://dev.mysql.com/doc/refman/5.7/en/while.html
[begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the search_condition expression is true. statement_list consists of one or more SQL statements, each ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.
https://dev.mysql.com/doc/refman/5.7/en/connectors-apis.html
Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment, including ODBC, Java (JDBC), C++, Python, PHP, Perl, Ruby, and native C and embedded MySQL instances. MySQL Connectors provide ...
https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html
After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information. In cases where you need to transfer databases between different architectures, you can use mysqldump ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory.html
The performance_schema directory corresponds to the Performance Schema, which provides information used to inspect the internal execution of the server at runtime. Information managed by the MySQL server is stored under a directory known as the ...
https://dev.mysql.com/doc/refman/5.7/en/deleting-from-related-tables.html
If the total length of the DELETE statement for related_table is more than 1MB (the default value of the max_allowed_packet system variable), you should split it into smaller parts and execute multiple DELETE statements. You probably get the ...