Search Results
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/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/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/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 ...
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/information-functions.html
Suppose that you generate an AUTO_INCREMENT value with one statement, and then refer to LAST_INSERT_ID() in a multiple-row INSERT statement that inserts rows into a table with its own AUTO_INCREMENT column. LAST_INSERT_ID(), LAST_INSERT_ID(expr) ...
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/innodb-locking.html
For example, SELECT c1 FROM t WHERE c1 BETWEEN 10 and 20 FOR UPDATE; prevents other transactions from inserting a value of 15 into column t.c1, whether or not there was already any such value in the column, because the gaps between all existing ...A ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each row inserted into the table. In the example, the trigger body is a simple SET that accumulates into ...Here is a simple example that associates a trigger with a table, to activate for INSERT ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in ...
https://dev.mysql.com/doc/refman/8.4/en/replace.html
As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not matching the given partition set. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name ...| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ...