Search Results
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-storage-engines.html
You can manually convert tables to InnoDB using the following ALTER TABLE statement: mysql> ALTER TABLE table_name ENGINE=InnoDB; The recommended method for migrating data is to use the MySQL Shell client. MySQL Shell dump utilities provide a ocimds ... MySQL Storage Engines 3.1.2.5 MySQL Storage Engines MySQL HeatWave on AWS supports only the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system schema. Important Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, ...This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional ...
https://dev.mysql.com/doc/refman/8.4/en/alter-instance.html
ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master encryption key used for InnoDB tablespace encryption. The updated TLS context properties are exposed in the Performance Schema tls_channel_status table. ALTER INSTANCE ...
https://dev.mysql.com/doc/refman/8.4/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET latin1 COLLATE latin1_swedish_ci; Tables created in the ... For ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.4/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. To list the display collations for a character set, use the INFORMATION_SCHEMA COLLATIONS table or the SHOW COLLATION ...
https://dev.mysql.com/doc/refman/8.4/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/doc/refman/8.4/en/comparisons-using-subqueries.html
It finds all rows in table t1 containing a value that occurs twice in a given column: SELECT * FROM t1 AS t WHERE 2 = (SELECT COUNT(*) FROM t1 WHERE t1.id = t.id); For a comparison of the subquery to a scalar, the subquery must return a scalar. The ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. Command Options for Connection ...These options can be given on the command line or in an option ...