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/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/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 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-insert-id.html
uint64_t mysql_stmt_insert_id(MYSQL_STMT *stmt) Description Returns the value generated for an AUTO_INCREMENT column by the prepared INSERT or UPDATE statement. Use this function after you have executed a prepared INSERT statement on a table which ...Return value is undefined if statement does not set AUTO_INCREMENT ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config-insert-set-user.html
For rows added to the sys_config table by INSERT statements, the sys_config_insert_set_user trigger sets the set_by column to the current user.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-insert-id.html
Syntax: insert_id = ccnx.insert_id() Returns the AUTO_INCREMENT value generated by the most recent executed statement, or 0 if there is no such value.