Search Results
https://dev.mysql.com/doc/refman/8.4/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
You can build a plugin as a static module (compiled into the server) or a dynamic module (built as a dynamic library that must be installed into the server using the INSTALL PLUGIN statement or the --plugin-load option before it can be used). The ...
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/table.html
With INTO to populate user variables, and with INTO OUTFILE or INTO DUMPFILE to write table data to a file. TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
Storage Engine Plugins The pluggable storage engine architecture used by MySQL Server enables storage engines to be written as plugins and loaded into and unloaded from a running server. In this role, the plugin reads the input to be parsed, splits ... The plugin API enables creation of plugins that implement several capabilities: Loadable functions (UDFs) Storage engines Full-text parsers Daemons INFORMATION_SCHEMA tables Semisynchronous replication Auditing Authentication Password validation and strength checking Protocol tracing Query rewriting Secure keyring storage and retrieval The following sections provide an overview of these plugin ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-switchover.html
A controlled switchover makes a selected replica cluster into the primary cluster for the InnoDB ClusterSet deployment. The process verifies that the selected replica cluster is synchronized with the primary cluster (which might mean a short wait ...The original primary cluster is demoted to a working read-only replica ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utils-copy.html
The copy utilities combine dump and load utilities into a single operation, for ease of use. The binary log information can be used after loading the copied data into the replica server to set up replication with a non-GTID source server, using the ... This section describes the MySQL Shell copy utilities: About the Utilities Requirements and Restrictions Running the Utilities Options for Copy Control Options for Filtering Examples About the Utilities The copy utilities enable you to copy DDL and data between MySQL instances, without the need for intermediate ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
If the server adds more internal data types that rely on BLOB storage like image manipulation, seeking into complex types in BLOBs, and more types will be added. Topics in this section: Message Structure Message Sequence Common Messages Connection ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your queries. As of MySQL 9.2.1, for context retrieval, the ML_RAG routine uses the name of the embedding model used to embed the input query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
This topic describes how to run a SELECT query and insert the results into a target table using the INSERT ... SELECT statement, the SELECT query is offloaded to MySQL HeatWave for execution, and result is copied into the target table in the DB ...