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/mysql-enterprise-monitor.html
Important MySQL Enterprise Monitor will be end of life and deprecated with obsolescence as of January 1, 2025. After this date, MySQL Enterprise Monitor will no longer receive security updates, non-security updates, bug fixes, or online technical ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
(In this case, simply using PARTITION BY KEY() would also be valid and have the same effect as PARTITION BY KEY(s1), since s1 is the table's primary key.) For additional information about this issue, see Section 26.6, “Restrictions and Limitations ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
There are also ways to obtain information about partitioned tables and partitions. For information about partition management in tables partitioned by RANGE or LIST, see Section 26.3.1, “Management of RANGE and LIST Partitions”. For a discussion ... There are a number of ways using SQL statements to modify partitioned tables; it is possible to add, drop, redefine, merge, or split existing partitions using the partitioning extensions to the ALTER TABLE ...
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 ...