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/partitioning-handling-nulls.html
We can verify this behavior by examining the effects on the file system of creating a table partitioned by HASH and populating it with a record containing appropriate values. Partitioning in MySQL does nothing to disallow NULL as the value of a ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-overview.html
For more information about permitted partitioning column types and partitioning functions, see Section 26.2, “Partitioning Types”, as well as Section 15.1.20, “CREATE TABLE Statement”, which provides partitioning syntax descriptions and ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
CREATE TABLE t1 ( ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, dt DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ); With a DEFAULT clause but no ON UPDATE CURRENT_TIMESTAMP clause, the column has the given ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. On Windows, you can create a ... On ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-types.html
It is important to remember—regardless of the type of partitioning that you use—that partitions are always numbered automatically and in sequence when created, starting with 0. However, it is not difficult in MySQL to create partitioning schemes ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
If you delete all rows in the table with DELETE FROM tbl_name (without a WHERE clause) in autocommit mode, the sequence starts over for all storage engines except InnoDB and MyISAM. In this case, reuse of values deleted from the top of the sequence ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.0/en/function-optimization.html
This might be zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. However, it might update zero, one, or multiple rows, depending on the id column values and the values in the RAND() sequence. A ...
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
One implication of this behavior is that for equal argument values, RAND(N) returns the same value each time, and thus produces a repeatable sequence of column values. In the following example, the sequence of values produced by RAND(3) is the same ...ABS(X) Returns the absolute value of X, or NULL if X is ...
https://dev.mysql.com/doc/refman/8.0/en/mrr-optimization.html
MRR iterates over a sequence of index ranges to obtain qualifying index tuples. The MRR optimization is not supported with secondary indexes created on virtual generated columns. Data rows are accessed according to the sorted index tuple sequence.
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type ...