PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/year.html
Note As of MySQL 8.0.19, the YEAR(4) data type with an explicit display width is deprecated and you should expect support for it to be removed in a future version of MySQL. For instructions on converting to 4-digit YEAR, see 2-Digit YEAR(2) ... The ...
https://dev.mysql.com/doc/refman/8.0/en/character-arrays.html
<collation> elements indicate character ordering for comparison and sorting, one element per collation. For a complex character set as implemented in a ctype-MYSET.c file in the strings directory, there are corresponding arrays: ctype_MYSET[], ...
https://dev.mysql.com/doc/refman/8.0/en/charset-we-sets.html
Western European character sets cover most West European languages, such as French, Spanish, Catalan, Basque, Portuguese, Italian, Albanian, Dutch, German, Danish, Swedish, Norwegian, Finnish, Faroese, Icelandic, Irish, Scottish, and English. This ...ascii (US ASCII) collations: ascii_bin ascii_general_ci (default) cp850 (DOS West European) collations: cp850_bin cp850_general_ci (default) dec8 (DEC Western European) collations: dec8_bin dec8_swedish_ci (default) The dec character set is deprecated in MySQL 8.0.28; expect support for it to be removed in a subsequent MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
The JSON_TABLE() function generates a table and provides another way to create a derived table: SELECT * FROM JSON_TABLE(arg_list) [AS] tbl_name ... The [AS] tbl_name clause is mandatory because every table in a FROM clause must have a name. This is ...For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived ...
https://dev.mysql.com/doc/refman/8.0/en/error-message-language.html
The lc_messages_dir system variable can be set only at server startup and has only a global read-only value at runtime. lc_messages can be set at server startup and has global and session values that can be modified at runtime. This applies to ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-elements.html
System variables enable firewall configuration and status variables provide runtime operational information. MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL examines SQL ...Tables in the mysql system database provide backing storage of firewall data for persistence of profiles across server ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometry.html
For example, in different coordinate systems, the distance between two objects may differ even when objects have the same coordinates, because the distance on the planar coordinate system and the distance on the geodetic system (coordinates on the ...It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-ssl-for-recovery.html
Important When using the MySQL communication stack (group_replication_communication_stack=MYSQL) AND secure connections between members (group_replication_ssl_mode is not set to DISABLED), the security settings discussed in this section are applied ...These options correspond to the server SSL options that are used for group communication connections, but they are only applied for distributed recovery ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-partition.html
You can use the system variable group_replication_unreachable_majority_timeout to set a number of seconds for a member to wait after losing contact with the majority of group members, and then exit the group. Setting a timeout means you do not need ...From MySQL 8.0.21, this feature is activated by default and the member makes three auto-rejoin ... By default, ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...