Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-innodb-insertbufferactivity-category.html
Lists the InnoDB Insert Buffer Activity metrics and provides a brief description of each. Table 6.12 InnoDB Insert Buffer Activity Metrics NameDescriptionDelete Discarded (Delta) The total number of purge merged operations discarded. Free List Len ...Delete Mark Discarded (Delta) The total number of deleted merged operations ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-insertdelayed-category.html
Lists the Insert Delayed configuration metrics and provides a brief description of each. Table 7.17 Insert Delayed Configuration Metrics NameDescriptionInsert Limit After inserting delayed_insert_limit delayed rows, the INSERT DELAYED handler ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-functionality-last-insert-id.html
Obtaining the value of column that uses AUTO_INCREMENT after an INSERT statement can be achieved in a number of different ways. To obtain the value immediately after an INSERT, use a SELECT query with the LAST_INSERT_ID() function. For example, ...
https://dev.mysql.com/doc/c-api/8.4/en/getting-unique-id.html
If you insert a record into a table that contains an AUTO_INCREMENT column, you can obtain the value stored into that column by calling the mysql_insert_id() function. When inserting multiple values, the last automatically incremented value is ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
The second example shows how you can retrieve the same value using a standard SELECT LAST_INSERT_ID() query. The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-insertdelayed-activity-category.html
Lists the Insert Delayed Activity metrics and provides a brief description of each. Table 6.19 Insert Delayed Activity Metrics NameDescriptionErrors (Delta) The number of rows written with INSERT DELAYED for which some error occurred (probably ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
The second example shows how you can retrieve the same value using a standard SELECT LAST_INSERT_ID() query. The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method.
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
It saves work for the developer, not to have to produce new unique values when inserting new rows. If you have innodb_autoinc_lock_mode=2, which allows higher concurrency for insert operations, use row-based replication rather than statement-based ... These terms are commonly used in information about the MySQL database ...