Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
Cursors inside stored programs are not supported before MySQL 9.0.0, see: Cursors. For example, the following query is not offloaded: mysql> SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; Primary keys with column prefixes. Queries that call a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-ml-stats-table.html
Note The Performance Schema table described here is available as of MySQL 9.0.0. Support for MySQL HeatWave GenAI routines is available as of MySQL 9.0.1-u1. The rpd_ml_stats table tracks the usage of successful MySQL HeatWave routines. The ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-exporting-data.html
Exporting Data 7.1 Exporting Data Use the dump utility of MySQL Shell to export a logical dump of the data from a MySQL instance. Connect to the MySQL instance containing the data you want to dump using MySQL Shell. Use either of the following dump ...You can dump all schemas in the instance, a selected schema, or selected tables and ...
https://dev.mysql.com/doc/refman/8.4/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica servers. MySQL offers a variety of backup strategies from which you can ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...This ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
If the DEFINER clause is present, the user value should be a MySQL account specified as 'user_name'@'host_name', CURRENT_USER, or CURRENT_USER(). MySQL checks view privileges like this: At view definition time, the view creator must have the ...If ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...The same principle applies to other table operations that require modifying data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For example, if a member is running MySQL 8.4.6 then that is the version of the Group Replication plugin. For optimal ...For ...