Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-auto-increment-values.html
X DevAPI provides the getAutoIncrementValue() method to return the first AUTO_INCREMENT column value that was successfully inserted by the operation, taken from the return value of table.insert(). In the following example it is assumed that the ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
It replaces literal values with placeholders and transforms multi-row insert statements and IN clauses, to group similar statements with different parameters when measuring how much time is consumed by a particular type of query. Includes not just ... These terms are commonly used in information about MySQL Enterprise ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-auto-increment-values.html
X DevAPI provides the getAutoIncrementValue() method to return the first AUTO_INCREMENT column value that was successfully inserted by the operation, taken from the return value of table.insert(). In the following example it is assumed that the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-auto-increment-values.html
X DevAPI provides the getAutoIncrementValue() method to return the first AUTO_INCREMENT column value that was successfully inserted by the operation, taken from the return value of table.insert(). In the following example it is assumed that the ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
For a MERGE table such as CREATE TABLE s1.t(i int) ENGINE MERGE UNION (s2.t, s3.t), INSERT_METHOD=..., the following behavior applies: Inserting into the MERGE table (INSERT into s1.t) fails if at least one of s1, s2, s3 is read only, regardless of ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
If strict SQL mode is enabled, attempts to insert invalid ENUM values result in an error. An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Does MySQL have statement-level or row-level triggers? All triggers are FOR EACH ROW; that is, the trigger is activated for each row that is inserted, updated, or deleted. For example, consider a table EMP that has an AFTER insert trigger, which ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-consistent-read.html
If you insert or modify some rows and then commit that transaction, a DELETE or UPDATE statement issued from another concurrent REPEATABLE READ transaction could affect those just-committed rows, even though the session could not query them. In the ... A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
For other search conditions, InnoDB locks the index range scanned, using gap locks or next-key locks to block insertions by other sessions into the gaps covered by the range. It is not recommended to mix locking statements (UPDATE, INSERT, DELETE, ... Transaction isolation is one of the foundations of database ...