Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
As of MySQL 9.4.0, you can set external table options using SQL syntax. The following options apply to CREATE TABLE and ALTER TABLE statements. For ALTER TABLE statements, ADD COLUMN is not supported for external tables. This topic contains the ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #37523857) Attempting to install an unknown component using INSTALL COMPONENT was not always handled correctly. (Bug #37370439) An UPDATE subsequent to an INSERT affecting a table which had a BEFORE INSERT trigger was sometimes rejected with a ...(Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
The data set can be empty if, for example, fetchOne() returns NULL or fetchAll() returns an empty list. When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
The data set can be empty if, for example, fetchOne() returns NULL or fetchAll() returns an empty list. When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
(This is an uncommon feature for implementations of hash indexes.) Columns that are indexed can contain NULL values. To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.4/en/insert.html
Warnings can occur under any of the following conditions: Inserting NULL into a column that has been declared NOT NULL. (For a single-row INSERT, no warning occurs when NULL is inserted into a NOT NULL column. INSERT [LOW_PRIORITY | DELAYED | ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: 100.00 Extra: Using index condition; Using filesort See also Section 10.9.2, ... If you ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-list.html
Note In MySQL 8.4, it is possible to match against only a list of integers (and possibly NULL—see Section 26.2.7, “How MySQL Partitioning Handles NULL”) when partitioning by LIST. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/internals/en/com-register-slave.html
Fields server_id (4) -- the slaves server-id slave_hostname (string.var_len) -- see report_host, usually empty slave_user (string.var_len) -- see report_user, usually empty slave_password (string.var_len) -- see report_password, usually empty ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
-- Attributes -- c1 Datetime NULL AT=FIXED ST=MEMORY c2 Date NULL AT=FIXED ST=MEMORY c3 Time NULL AT=FIXED ST=MEMORY c4 Timestamp NOT NULL AT=FIXED ST=MEMORY DEFAULT 0 c5 Year NULL AT=FIXED ST=MEMORY The affected MySQL types are TIME, DATETIME, and ... This section provides information about the way in which MySQL data types are represented in NDBCLUSTER table columns and how these values can be accessed in NDB API ...