PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. A 6-byte DB_ROW_ID field contains a row ID that ...It ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. SELECT statements that insert zero or NULL values into an ...
https://dev.mysql.com/doc/refman/5.7/en/loading-tables.html
When you want to add new records one at a time, the INSERT statement is useful. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> INSERT INTO pet VALUES ...Suppose that ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
You can use SELECT, DELETE, UPDATE, and INSERT on MERGE tables. You can optionally specify an INSERT_METHOD option to control how inserts into the MERGE table take place. Use a value of FIRST or LAST to cause inserts to be made in the first or last ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
When rows are inserted in sorted order (as when you are using an AUTO_INCREMENT column), the index tree is split so that the high node only contains one key. Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
Now the Performance Schema determines how to set the INSTRUMENTED and HISTORY values for new connection threads as follows: If joe connects from the local host, the connection matches the first inserted row. If joe connects from hosta.example.com, ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
However, the result of the DML INSERT statement is different depending on the binary logging format: If row-based binary logging format is in use on the source (binlog_format=ROW), the replica evaluates the INSERT operation using the database where ... If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/5.7/en/triggers.html
Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an update. A trigger is defined to activate when a statement inserts, updates, or deletes rows in the associated ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
This makes MySQL very convenient for Web applications where you obtain year, month, and day in three different fields and you want to store exactly what the user inserted (without date validation). You should use this format in UPDATE expressions ...