Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-0.html
(WL #16450) MySQL HeatWave now supports offloading the INSERT INTO SELECT queries to the secondary engine, even when the table being inserted into has triggers defined on it. This enables faster query execution and improved performance for workloads ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-performance-extensions.html
Default Value 0 Since Version 3.1.9 dontCheckOnDuplicateKeyUpdateInSQL Stops checking if every INSERT statement contains the "ON DUPLICATE KEY UPDATE" clause. 'Statement.getGeneratedKeys()', for statements that are rewritten only works when the ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-1-0.html
(Bug #36936407) When using PreparedStatements, negative DATE values were inserted as some positive values instead of being rejected. (Bug #113509, Bug #36154975) After using executeBatch() to insert rows into a table and adding more rows with ...
https://dev.mysql.com/doc/refman/9.7/en/account-categories.html
By direct grant-table modification using statements such as INSERT and UPDATE. MySQL incorporates the concept of user account categories, based on the SYSTEM_USER privilege. The SYSTEM_USER privilege has an effect on the accounts to which a given ...
https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. To specify a separator explicitly, use SEPARATOR followed by the string literal value that should be inserted between group ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row. In that case, a (child table) row containing such a foreign key can be inserted even though it does not match ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...
https://dev.mysql.com/doc/refman/9.7/en/atomic-ddl.html
SELECT is applied as an atomic operation, a metadata lock is held on the table while data is inserted, which prevents concurrent access to the table for the duration of the operation. An atomic DDL statement combines the data dictionary updates, ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log.html
Within an uncommitted transaction, all updates (UPDATE, DELETE, or INSERT) that change transactional tables such as InnoDB tables are cached until a COMMIT statement is received by the server. If you are using the binary log and row based logging, ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf16.html
Because utf16 supports surrogates and ucs2 does not, there is a validity check that applies only in utf16: You cannot insert a top surrogate without a bottom surrogate, or vice versa. For example, since U+F8FF is the Apple Logo, this is legal: ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
For details, including the return value after a multiple-row insert, see Section 14.15, “Information Functions”. If no AUTO_INCREMENT value was successfully inserted, the SELECT statement returns no row. Table 14.4 Comparison Operators Name ...