Search Results
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/mysql-errors/9.7/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/9.7/en/jdv-requirements.html
This is only possible if the insertion into the column with the AUTO_INCREMENT attribute has already occurred. This is only possible if the insertion into the column with the AUTO_INCREMENT attribute has already occurred. INSERT INTO ...Requirements ... Review the following requirements and restrictions for table annotations and DML operations on JSON duality ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/refman/9.7/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 ...