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/change-replication-filter.html
Names of tables and database not containing any special characters need not be quoted. Values used with REPLICATION_WILD_TABLE and REPLICATION_WILD_IGNORE_TABLE are string expressions, possibly containing (special) wildcard characters, and so must ...Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD first (and restarted with START REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.0/en/channels-naming-conventions.html
Each replication channel has a unique name which is a string with a maximum length of 64 characters and is case-insensitive. Because channel names are used in the replica's applier metadata repository table, the character set used for these is ...
https://dev.mysql.com/doc/refman/8.0/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated in MySQL 8.0.28.
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
(In these examples, mydb is not interpreted as a password because it is separated from the preceding password option by a space.) On some systems, the library routine that MySQL uses to prompt for a password automatically limits the password to ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
The event_name must be a valid MySQL identifier with a maximum length of 64 characters. comment may be any string of up to 64 characters that you wish to use for describing the event. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
The combination of the ORGANIZATION org_name and org_id attribute values must be unique. String values in attribute specifications cannot contain control characters, including newline. Table 15.6 CREATE SPATIAL REFERENCE SYSTEM Attribute Lengths ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-files.html
If a table name contains special characters, the names for the table files contain encoded versions of those characters as described in Section 11.2.4, “Mapping of Identifiers to File Names”. For an InnoDB table created in a file-per-table ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
For nonbinary (character) string columns, the character set and collation must be the same. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/create-view.html
Aliases for column names in the SELECT statement are checked against the maximum column length of 64 characters (not the maximum alias length of 256 characters). The valid SQL SECURITY characteristic values are DEFINER (the default) and INVOKER. For ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
The account can be used to connect to the server from all machines in the domain due to use of the % wildcard character in the host part of the account name. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER ...