Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
You cannot directly update a materialized view, so INSERT, UPDATE, and DELETE statements do not work with materialized views. This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL 9.5.0. A ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-functions-operators.html
With the exception of the FORMAT() function, string functions and operators described in the following table are supported with variable-length encoded columns. FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-catalog.html
ML_TRAIN inserts the model as a row in the MODEL_CATALOG table at the end of training. MySQL HeatWave AutoML stores machine learning models in a model catalog. MySQL HeatWave AutoML creates a model catalog for any user that creates a machine ...
https://dev.mysql.com/doc/heatwave-aws/en/autopilot-index-advisor.html
Indexes can improve query performance of SELECT statements, but managing the indexes increases the overhead of INSERT, UPDATE, and DELETE statements. Autopilot Index Advisor 11 Autopilot Index Advisor Autopilot Index Advisor provides secondary ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-connection.html
"affected rows" for DML statements, but does cause correct update counts from "INSERT ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
https://dev.mysql.com/doc/connector-j/en/connector-j-WebAuthn-authentication.html
In either case, issue the following command (additional command options to connect to the right server might be needed): $ mysql --user=johndoe --password1 --register-factor=2 Enter password: <type "s3cr3t"> Please insert FIDO device and follow the ... Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts).
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
It is also possible to modify the audit log tables directly using statements such as INSERT, UPDATE, and DELETE, but such changes do not affect filtering immediately. Note For audit log filtering to work as described here, the audit log plugin and ...