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/mysql-cluster-replication-conflict-resolution.html
Both NDB$EPOCH() and NDB$EPOCH_TRANS() insert entries for conflicting rows into the relevant exceptions tables, provided that these tables have been defined according to the same exceptions table schema rules as described elsewhere in this section ...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 ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
Otherwise, MySQL acquires a normal write lock and inserts the row into the hole. Exception: Attempting to insert NULL into a generated column declared as TIMESTAMP NOT NULL is rejected with an error. It is an unsupported combination that could ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1671; Symbol: ER_BINLOG_UNSAFE_AUTOINC_COLUMNS; SQLSTATE: HY000 Message: Statement is unsafe because it invokes a trigger or a stored function that inserts into an AUTO_INCREMENT column. [%s.%s] Error number: 1727; Symbol: ...If the ...
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
If you are using a recent version of mysqldump to generate a dump to be reloaded into a very old MySQL server, use the --skip-opt option instead of the --opt or --extended-insert option. Dumps can be easily imported into a MySQL Server instance or a ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
Within a stored procedure p(), we attempt to insert two values into a table that contains a TEXT NOT NULL column. GET DIAGNOSTICS can obtain either statement or condition information, but not both in the same statement: To obtain statement ... GET ...
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. For example, in a UNION, scanned (and locked) rows from a table might be inserted into a temporary table before evaluating whether they ...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 becomes locked, which in turn blocks all inserts by other users to the ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
Issuing multiple GRANT statements containing wildcards may not have the expected effect on DML statements; when resolving grants involving wildcards, MySQL takes only the first matching grant into consideration. For example, this statement grants ...