Search Results
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-9-0-0.html
Now the SQLConnect() values are prioritized except for SQLConnect() values defined as NULL. Functionality Added or Changed Bugs Fixed Functionality Added or Changed For the ANSI driver, converting to and from the character set specified by the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
For example, the following query is not offloaded: mysql> SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; Primary keys with column prefixes. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in ...
https://dev.mysql.com/doc/refman/8.4/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. This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-files.html
The files table is empty if no disk data objects have been created in NDB. See Section 25.6.11.1, “NDB Cluster Disk Data Objects”, for more information.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-quick.html
To familiarize you with the basics, we describe the simplest possible configuration for a functional NDB Cluster. After this, you should be able to design your desired setup from the information provided in the other relevant sections of this ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the server writes diagnostics to a file on the server host or to a system log service.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
Generally, the effect is to reset the summary columns to 0 or NULL, not to remove rows. Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. Pre-filtering can be applied to either the producer or ...