PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-auto-increment-handling.html
InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT columns. The following terms are used in describing innodb_autoinc_lock_mode ...To use the AUTO_INCREMENT mechanism with an InnoDB table, an AUTO_INCREMENT column must be defined as the first or only column of some index such that it is possible to perform the equivalent of an indexed SELECT MAX(ai_col) lookup on the table to obtain the maximum column ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
Other transactions can update or delete the same rows you just queried. FOR SHARE Sets a shared mode lock on any rows that are read. Other sessions can read the rows, but cannot modify them until your transaction commits. If any of these rows were ... If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-range.html
Placement of rows in RANGE COLUMNS partitions is also based on comparisons between tuples; this is discussed further later in this section. Placement of rows into partitions is determined by comparing the tuple from a row to be inserted that matches ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...Window functions are permitted only in the select list and ORDER BY ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
This being the case, we discuss in this section how each MySQL partitioning type handles NULL values when determining the partition in which a row should be stored, and provide examples for each. If you insert a row into a table partitioned by RANGE ... Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-print-backup-file.html
This option is enabled by default; to disable it, use --no-print-rows. --rowid-file Command-Line Format --rowid-file=path Type File name Default Value [none] File to check for row ID. This can be any of the files (.Data, .ctl, or .log file) found in ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
However, prior to MySQL 8.0.21, when row-based replication is in use, a CREATE TABLE ... SELECT is now recorded and applied as one transaction when row-based replication is in use. You can precede the SELECT by IGNORE or REPLACE to indicate how to ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/trigger-syntax.html
In this case, the trigger activates before each row inserted into the table. The statement following FOR EACH ROW defines the trigger body; that is, the statement to execute each time the trigger activates, which occurs once for each row affected by ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html
row *************************** Level: Error Code: 3934 Message: The JSON document location '#/latitude' failed requirement 'maximum' at JSON Schema location '#/properties/latitude'. row *************************** Level: Error Code: 3819 Message: ... Beginning with MySQL 8.0.17, MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema ...