Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-execute.html
Statement processing following mysql_stmt_execute() depends on the type of statement: For an UPDATE, DELETE, or INSERT, the number of changed, deleted, or inserted rows can be found by calling mysql_stmt_affected_rows(). int ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
(This also means that DataMemory pages, once allocated to a given table, cannot be used by other tables.) Performing a data node recovery also compresses the partition because all records are inserted into empty partitions from other live nodes.
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also possible to assign NULL to the column to generate sequence numbers. For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); ...You can retrieve the most recent automatically generated AUTO_INCREMENT value with the LAST_INSERT_ID() SQL function or the mysql_insert_id() C API ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
For the third INSERT statement, the VALUES() list must provide the same number of values as the number of named columns; the same is true when you use VALUES ROW() rather than VALUES(). For statements that insert or ignore new rows, or that replace ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
The NDB injector is responsible for capturing all the data events within the cluster, and ensures that all events which change, insert, or delete data are recorded in the ndb_binlog_index table. Splitting replication streams into two (or more) ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-change-buffer.html
The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when the pages are loaded into the buffer pool by other read operations. Figure 17.3 Change Buffer Unlike clustered indexes, secondary indexes ...Merging cached changes at a later time, when affected pages are read into the buffer pool by other operations, avoids substantial random access I/O that would be required to read secondary index pages into the buffer pool from ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
These trigger_event values are permitted: INSERT: The trigger activates whenever a new row is inserted into the table (for example, through INSERT, LOAD DATA, and REPLACE statements). For example, an INSERT trigger activates not only for INSERT ...A ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 0 MAX_COUNT: 0 MIN_COUNT: NULL AVG_COUNT: 0 COUNT_RESET: 0 MAX_COUNT_RESET: 0 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 TIME_DISABLED: NULL ...Create a simple InnoDB table: mysql> USE test; Database changed mysql> CREATE TABLE t1 (c1 INT) ENGINE=INNODB; Query OK, 0 rows affected (0.02 sec) Enable the dml_inserts ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
ndb_log_binlog_index Command-Line Format --ndb-log-binlog-index[={OFF|ON}] System Variable ndb_log_binlog_index Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Causes a mapping of epochs to positions in the binary log ...When this option is enabled, and both --ndb-log-updated-only and --ndb-log-update-minimal are disabled, operations of different types are loǵged as described in the following list: INSERT: Logged as a WRITE_ROW event with no before image; the after image is logged with all ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. For InnoDB: An INSERT statement that uses AUTO_INCREMENT blocks other nonconflicting INSERT statements.