Search Results
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. Consider this view: CREATE VIEW v AS SELECT col1, 1 AS col2 FROM t; This view is not insertable because col2 is an expression. Some views are ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
For more information, see Section 10.2.2.5, “Derived Condition Pushdown Optimization” Derived Table Merging Flags derived_merge (default on) Controls merging of derived tables and views into outer query block. The derived_merge flag controls ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-key.html
PARTITION BY KEY are similar to those for creating a table that is partitioned by hash. In both of these cases, the partitioning key is the id column, even though it is not shown in the output of SHOW CREATE TABLE or in the PARTITION_EXPRESSION ...
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE statement supports AVG_ROW_LENGTH and MAX_ROWS options. The effective maximum table size for MySQL databases is ...For ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-agent-rights.html
Note If monitoring MySQL Server 5.5, you must also grant CREATE and INSERT privileges on the schema the inventory table is created on. The inventory table stores unique identifiers for the MySQL instance, and is created in the mysql schema by ...The ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. While the examples work as shown for purposes of the present discussion, you ...Ranges should be contiguous but not overlapping, and are defined using the VALUES LESS THAN ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-simple-dual.html
This example demonstrates synchronous transactions and connecting to multiple clusters in a single NDB API application. The source code for this program may be found in the NDB Cluster source tree, in the file ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-issues.html
Note Every NDB table is implicitly partitioned by key when it is created. In the event of a node failure, errors in replication of NDB tables without primary keys can still occur, due to the possibility of duplicate rows being inserted in such cases. For this reason, it is highly recommended that all NDB tables being replicated have explicit primary ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-run-chat.html
In this topic, the HEATWAVE_CHAT routine uses the vector store table demo_embeddings created in the section Ingesting Files into a Vector Store for context retrieval. To use your own embedding table for context retrieval, create a table that ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Functional key parts (see Section 15.1.15, “CREATE INDEX Statement”) are implemented as hidden virtual generated stored columns, so each functional key part in a table index counts against the table total column limit. mysql> CREATE TABLE t (a ... This section describes limits on the number of columns in tables and the size of individual ...The storage ...