Search Results
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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/jdv-requirements.html
Requirements and Restrictions for Insert Annotations The root object and sub-objects of a document must have the INSERT annotation. If a sub-object is updated as part of an insert operation, this sub-object must have the UPDATE annotation. Review ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/mysql-errors/9.7/en/server-error-reference.html
For example, if the error occurs for a large INSERT, perform several smaller INSERT operations. Error number: 1671; Symbol: ER_BINLOG_UNSAFE_AUTOINC_COLUMNS; SQLSTATE: HY000 Message: Statement is unsafe because it invokes a trigger or a stored ...
https://dev.mysql.com/doc/refman/9.7/en/get-diagnostics.html
Here is an example that uses GET DIAGNOSTICS and an exception handler in stored procedure context to assess the outcome of an insert operation. If the insert was successful, the procedure uses GET DIAGNOSTICS to get the rows-affected count. Within a ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...