Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
You can optionally specify an INSERT_METHOD option to control how inserts into the MERGE table take place. If you specify no INSERT_METHOD option or if you specify it with a value of NO, inserts into the MERGE table are not permitted and attempts to ...You can use SELECT, DELETE, UPDATE, and INSERT on MERGE ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
The WITH CHECK OPTION clause can be given to constrain inserts or updates to rows in tables referenced by the view. This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
MyISAM Tables In MyISAM tables, deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. DELETE QUICK is most useful for applications where index values for deleted rows are replaced by similar index ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/timestamp-initialization.html
For example: INSERT INTO t2 VALUES (CURRENT_TIMESTAMP); INSERT INTO t1 VALUES (NOW()); If the explicit_defaults_for_timestamp system variable is enabled, TIMESTAMP columns permit NULL values only if declared with the NULL attribute. For any ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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. For example, you can have a trigger activate before each row that is inserted into a table or after each ...A trigger is defined to activate when a statement inserts, updates, or deletes rows in the associated ... A trigger is a named ...
https://dev.mysql.com/doc/x-devapi-userguide/en/understanding-automatic-document-ids.html
Important X Plugin is not aware of the data inserted into the collection, including any manual document IDs you use. Document ID Properties The _id field of a document behaves in the same way as any other fields of the document during queries, ...