Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Global privileges such as DROP, ALTER, DELETE, UPDATE, INSERT, and LOCK TABLES may be dangerous as they may cause other users to be affected adversely. This advisor enables you to define a regular expression describing the users allowed to have ...
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, ...
https://dev.mysql.com/doc/refman/8.4/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 ...