Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
When using insertTuple(), you may also define the search key with setValue(). NdbOperation::insertTuple() Description This method defines the NdbOperation to be an INSERT operation. To set a NULL value, use the following construct: ...Beginning with ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-32.html
(Bug #108733, Bug #34689812) The MySQLCursor.executemany() method failed to batch insert data because the regular expression (RE) sentinel did not detect batch cases correctly; this meant using a one-on-one insert instead, which led to poor ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-24.html
For example, the following query, where L_LINESTATUS is a VARLEN-encoded string column, can now be offloaded to MySQL HeatWave: SELECT COUNT(*) FROM lineitem WHERE L_LINESTATUS >= 1 and L_LINESTATUS <= 10; (Bug #31721399) MySQL HeatWave now supports ... Functionality Added or Changed Comparison of different temporal type values is now ...
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/refman/8.4/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/8.4/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/8.4/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, ...