PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/channels-with-prev-replication.html
For example, the following statements behave as expected for all except certain Group Replication channels: START REPLICA starts replication threads for all channels, except the group_replication_recovery and group_replication_applier channels. STOP ... When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific ...
https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html
There is one subsection for each group of related character sets. To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To avoid choosing the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-configuration.html
For example, to specify a directory to be used by MySQL client programs, list it in the [client] group of your option file. The MySQL server has a compiled-in default character set and collation. To change these defaults, use the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
These variables can be changed individually using SET statements, but two more convenient statements affect the connection-related character set system variables as a group: SET NAMES 'charset_name' [COLLATE 'collation_name'] SET NAMES indicates ...
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html
Also, any program that uses libmysqlclient and reads option files can enable the plugin by including an enable-cleartext-plugin option in an option group read by the client library. A client-side authentication plugin is available that enables ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-failure-handling.html
Configuring a longer timeout allows more time for resolving network issues but also increases the size of the delta on the donor instance, which increases clone recovery time as well as replication lag in cases where the clone is intended as a ...
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
The AGGREGATE keyword, if given, signifies that the function is an aggregate (group) function. CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
InnoDB permits a foreign key to reference any index column or group of columns. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...