Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ...There is an exception that nontransactional DML is allowed in the same transaction or in the same statement as transactional DML, if all nontransactional tables are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable to 0. OutputTableName: the name of the table where you want to create a new column to ...
https://dev.mysql.com/doc/refman/8.4/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
Miscellaneous Information The xxx_general_mysql500_ci collations preserve the pre-5.1.24 ordering of the original xxx_general_ci collations and permit upgrades for tables created before MySQL 5.1.24 (Bug #27877). utf8mb3 is also displayed in place ... This section describes the collations available for Unicode character sets and their differentiating ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
If you are uninstalling a plugin with no intention of reinstalling it later and you care about the table contents, you should dump the table with mysqldump and remove the WITH PARSER clause from the dumped CREATE TABLE statement so that you can ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. To use a dictionary, it must first be added to the masking_dictionaries system table ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
In a newly created system tablespace, InnoDB allocates space starting from the first data file. To avoid the issues that come with storing all tables and indexes inside the system tablespace, you can enable the innodb_file_per_table configuration ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-simple.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using local functions. It then reads the columns back and extracts the data from them using local functions. See Section 2.5.15, “Common Files ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ...A single-row subquery from a table or tables is not considered a ... When an operator is used with operands of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...