Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-reserved-words.html
For example, a table column named rank on a MySQL 5.7 source that is replicating to a MySQL 8.4 replica could cause a problem because RANK became a reserved word in MySQL 8.0. Replication can fail in such cases with Error 1064 You have an error in ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
To encrypt data in an InnoDB file-per-table tablespace, run ALTER TABLE tbl_name ENCRYPTION = 'Y'. To encrypt a general tablespace or the mysql tablespace, run ALTER TABLESPACE tablespace_name ENCRYPTION = 'Y'. Does the transportable tablespaces ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-vector-store-overview.html
However, for query offload to be successful, the vector table must be offloaded to AI engine using the SECONDARY_LOAD clause with the ALTER TABLE statement, and the query (SELECT statement) must use at least one vector function in the SELECT LIST, ...About Accelerated Processing of Queries on Vector-Based Tables GenAI lets you run queries on tables that contain vector embeddings at an accelerated pace by offloading them to the MySQL AI Engine (AI ...
https://dev.mysql.com/doc/internals/en/myisam-column-attributes.html
Some further random notes about the new format: In old tables (from MySQL 4.1 and earlier), VARCHAR columns have type MYSQL_TYPE_VAR_STRING, which works exactly like a CHAR with the exception that if you do an ALTER TABLE, it's converted to a true ...(This means that old tables will work as before for users.) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
You can define the encoding type while creating the table or later modify it using ALTER TABLE statement. Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-0.html
This feature allows for the creation of secondary indexes during the bulk load process, reducing the need for additional ALTER TABLE statements. (WL #16266, WL #15986) MySQL HeatWave now supports JSON tables, enabling you to extract data from JSON ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A number of features supported by other storage engines are not supported for NDB tables. A ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; however, errors may occur in applications that expects the features to be supported or ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
In the preceding discussion, the data set stored in tstable happens to consist of distinct UTC values. If the index is not UNIQUE, it is possible for the table (and the index) to store multiple instances of a given UTC value. Temporal values are ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
ALTER TABLE City ENGINE=InnoDB; ALTER TABLE Country ENGINE=InnoDB; ALTER TABLE CountryLanguage ENGINE=InnoDB; A good programming practice emphasized by Spring is separating interfaces and implementations. To use transactional database access, we ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
ALTER TABLE City ENGINE=InnoDB; ALTER TABLE Country ENGINE=InnoDB; ALTER TABLE CountryLanguage ENGINE=InnoDB; A good programming practice emphasized by Spring is separating interfaces and implementations. To use transactional database access, we ...