PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/using-date.html
When a '0000-00-00' date is used through Connector/ODBC, it is automatically converted to NULL because ODBC cannot handle that kind of date. MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” This is in some cases ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/window-function-restrictions.html
The SQL standard imposes a constraint on window functions that they cannot be used in UPDATE or DELETE statements to update rows. Using such functions in a subquery of these statements (to select rows) is permitted. MySQL does not support these ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-logging-configuration.html
If the system variable value is OFF, a null value is written to the log file for these fields. This section describes how to configure audit logging characteristics, such as the file to which the audit log component writes events, the format of ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-logging-configuration.html
If the system variable value is OFF, a null value is written to the log file for these fields. Important The audit_log plugin is deprecated, and is being replaced by the audit_log component. Deprecation of the plugin means that you should expect ...
https://dev.mysql.com/doc/refman/9.7/en/charset-collation-implementations.html
Example: "U+0000 NULL" does not have a weight and is ignorable. MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one ...
https://dev.mysql.com/doc/refman/9.7/en/charset-conversion.html
For example, if you specified NOT NULL and an explicit DEFAULT value, you should also provide them in the ALTER TABLE statement. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful ...
https://dev.mysql.com/doc/refman/9.7/en/charset-errors.html
If character_set_results has a value of NULL or binary, no conversion occurs. This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the ...
https://dev.mysql.com/doc/refman/9.7/en/charset-metadata.html
If character_set_results is set to NULL, no conversion is performed and the server returns metadata using its original character set (the set indicated by character_set_system). Metadata is “the data about the data.” Anything that describes the ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-options-variables.html
clone_valid_donor_list Command-Line Format --clone-valid-donor-list=value System Variable clone_valid_donor_list Scope Global Dynamic Yes SET_VAR Hint Applies No Type String Default Value NULL Defines valid donor host addresses for remote cloning ...