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/comparison-operators.html
Note In previous versions of MySQL, when evaluating an expression containing LEAST() or GREATEST(), the server attempted to guess the context in which the function was used, and to coerce the function's arguments to the data type of the expression ...The following relational comparison operators can be used to compare not only scalar operands, but row operands: = > < >= <= <> != The descriptions for those operators later in this section detail how they work with row ... Table 14.4 ...
https://dev.mysql.com/doc/refman/8.0/en/compatibility.html
MySQL supports a native JSON data type as defined by RFC 7159, and based on the ECMAScript standard (ECMA-262). Modes affect the SQL syntax MySQL supports and the data validation checks it performs. This makes it easier to use MySQL in different ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-optimizer.html
The server maintains histogram statistics about column values in the column_statistics data dictionary table (see Section 10.9.6, “Optimizer Statistics”). Like other data dictionary tables, this table is not directly accessible by users. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Storing birth date rather than age has other advantages, too: You can use the database for tasks such as generating reminders for upcoming pet birthdays. For example, if you store death date in the database, you can easily calculate how old a pet ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-information-schema.html
Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA? A.7.5. Can I add to or otherwise modify the tables found in the ...Where can I ...However, Oracle and MySQL use different table names and column ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-background.html
Specifically, replicated databases have to deal with the fact that they require maintenance and administration of several servers instead of just one. Therefore, the ultimate challenge is to fuse the logic of the database and data replication with ...The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-message-compression.html
If you use binary log transaction compression in combination with Group Replication's message compression, message compression has less opportunity to act on the data, but can still compress headers and those events and transaction payloads that are ...Whether a specific message is compressed depends on the threshold that you configure using the group_replication_compression_threshold system ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-management.html
The second method involves studying the contents of the cluster log ndb_node_id_cluster.log; this is usually found in the management server's DataDir directory, but this location can be overridden using the LogDestination option. More detailed ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html
The permitted data types are shown in the following list: All integer types: TINYINT, SMALLINT, MEDIUMINT, INT (INTEGER), and BIGINT. (This is the same as with partitioning by RANGE and LIST.) Other numeric data types (such as DECIMAL or FLOAT) are ... The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...