Search Results
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.
https://dev.mysql.com/doc/internals/en/com-delayed-insert.html
COM_DELAYED_INSERT: an internal command in the server Payload 1 [10] COM_DELAYED_INSERT Returns ERR_Packet .
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-last-insert-id.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects (see Section 14.15, “Information Functions”). The ...For stored functions and triggers that change the value, the value is restored when the function or trigger ends, so following statements do not see a changed ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. STRICT_TRANS_TABLES If a value could not be inserted as ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
When using NDB$MAX_INS() or NDB$MAX_DEL_WIN_INS(), NDB can apply WRITE_ROW events idempotently, mapping such an event to an insert when the incoming row does not already exist, or to an update if it does. Both NDB$EPOCH() and NDB$EPOCH_TRANS() ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
The result indicates that u1 has global SELECT and INSERT privileges, except that INSERT cannot be exercised for tables in the world schema. It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled.
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
With large data sizes, even if the backup step takes a reasonable time, restoring the data can be very slow because replaying the SQL statements involves disk I/O for insertion, index creation, and so on. If you are using a recent version of ... The ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
bulk_insert_buffer_size Command-Line Format --bulk-insert-buffer-size=# System Variable bulk_insert_buffer_size Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Integer Default Value 8388608 Minimum Value 0 Maximum Value (64-bit ...