PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
This can lead to inconsistent data being returned and unexpectedly failed statements. ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
When sampling user data as part of building a histogram, not all values are read; this may lead to missing some values considered important. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
The plugin interprets the audit_log_file value as composed of an optional leading directory name, a base name, and an optional suffix. This section describes how to configure audit logging characteristics, such as the file to which the audit log ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-setting.html
It is possible to change the logging format to STATEMENT, but doing so at runtime leads very rapidly to errors because InnoDB can no longer perform inserts. You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
You can use the --log-bin option to specify an alternative location, by adding a leading absolute path name to the base name to specify a different directory. The binary log contains “events” that describe database changes such as table ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
When CONVERT() was used as part of the expression for an indexed generated column, this could lead to index corruption following an upgrade from a previous version of MySQL. Table 14.15 Cast Functions and Operators Name Description Deprecated ...
https://dev.mysql.com/doc/refman/8.0/en/charset-syntax.html
The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads to natural and obvious results. There are default settings for character sets and collations at four levels: ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
Also, keep in mind the general principle that if a table has different definitions on the source and replica, this can lead to unexpected results. This section describes issues that you may face when converting character data between the utf8mb3 ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
For _bin collations except utf8mb4_0900_bin, the weight is based on the code point, possibly with leading zero bytes added. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL ...