PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.0/en/if.html
[ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which differs from the IF statement described here. The IF statement can have THEN, ELSE, and ELSEIF ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-and-mysql-replication.html
It is possible to use replication in a way where the storage engine on the replica is not the same as the storage engine on the source. For example, you can replicate modifications to an InnoDB table on the source to a MyISAM table on the replica.
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each other. search_str and path are always interpreted as utf8mb4 strings, regardless of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage engine. One of these is to modify the table definition before importing it into the Cluster database. Then modify the table ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
Here is a sample histogram object: { "buckets": [ [ 1, 0.3333333333333333 ], [ 2, 0.6666666666666666 ], [ 3, 1 ] ], "null-values": 0, "last-updated": "2017-03-24 13:32:40.000000", "sampling-rate": 1, "histogram-type": "singleton", ... The ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
If a table has triggers, attempts to rename the table into a different database fail with a Trigger in wrong schema (ER_TRG_IN_WRONG_SCHEMA) error. RENAME TABLE works for views, except that views cannot be renamed into a different database. RENAME ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...