Search Results
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
Partitioning: Truncating a partition was rejected with a duplicate entry error when the partition ID exceeded INT_MAX, preventing creation of new partitioned tables. (Bug #35912852) Replication: When using replication in a chain, CREATE TABLE ...
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 ...
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/internals/en/implementing-rnd-next-method.html
In each format, the columns appear in the order in which they were defined by the CREATE TABLE statement. After the table is initialized, the MySQL server will call the handler's [custom-engine.html#custom-engine-api-reference-rnd_next rnd_next()] ...The rnd_next() method takes a single byte array parameter named ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
An example of such a query, using the table t1 created previously, is shown here: mysql> EXPLAIN -> SELECT * FROM t1 AS x -> LEFT JOIN t1 AS y -> ON x.a=0 AND y.b>=3\G *************************** 1. Joins are not directly supported; conditions ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-metrics-table.html
Create a simple InnoDB table: mysql> USE test; Database changed mysql> CREATE TABLE t1 (c1 INT) ENGINE=INNODB; Query OK, 0 rows affected (0.02 sec) Enable the dml_inserts counter. The INNODB_METRICS table provides information about InnoDB ...SET ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
To exclude a column, specify the NOT SECONDARY column attribute in an ALTER TABLE or CREATE TABLE statement, as shown below. mysql> ALTER TABLE tbl_name MODIFY column_name datatype NOT SECONDARY; mysql> CREATE TABLE tbl_name ( column_1 datatype, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
This reflects the creation of the hidden primary key that is a feature of all tables using the NDB storage engine. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ... A number of types of statistical counters relating to actions performed by or affecting Ndb objects are ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
OutputTableName: the name of the table where you want to create a new column to store the generated outputs. If the specified table doesn't exist, a new table is created. If you created a new database for testing the steps in this section, delete ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
You can identify the current primary using the MEMBER_ROLE column in the Performance Schema replication_group_members table. In MySQL 8.4, it also waits for the completion of any ongoing DDL statements such as ALTER TABLE. The following function ...