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/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 ...
https://dev.mysql.com/doc/refman/8.4/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] ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
For example, this statement grants the SELECT and INSERT privileges globally: GRANT SELECT, INSERT ON *.* TO u1; The globally granted privileges apply to all databases, tables, and columns, even though not granted at any of those lower levels. To ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
The locks are normally next-key locks that also block inserts into the “gap” immediately before the record. If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...