Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
However, there is one important difference in the effect this has on your use of the table afterward: You can no longer insert into the table any rows having any of the values that were included in the value list defining the deleted partition.
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. STRICT_TRANS_TABLES If a value could not be inserted as ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-instance-schema.html
MySQL Shell's instance dump utility util.dumpInstance() and schema dump utility util.dumpSchemas(), support the export of all schemas or a selected schema from an on-premise MySQL instance into an Oracle Cloud Infrastructure Object Storage bucket ...The table dump utility util.dumpTables() supports the same operations for a selection of tables or views from a ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-byo-embedding-tables.html
While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System table.", "distance": 0.1028, "document_name": "" } ], "vector_store": ["`demo_db`.`demo_embeddings`", "`demo_db`.`demo_e5_table`"], ... GenAI lets you use tables containing your own vector embedding to run retrieval-augmented generation (RAG) with vector ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
As of MySQL 9.2.1, MySQL HeatWave GenAI lets you use tables containing your own vector embedding to run retrieval-augemented generation (RAG) with vector search. The ML_RAG and ML_RAG_TABLE routines let you specify the table column names to use as ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
The JSON_TYPE() function expects a JSON argument and attempts to parse it into a JSON value. One way to insert this as a JSON object into the facts table is to use the MySQL JSON_OBJECT() function. In contexts that combine multiple arrays, the ...
https://dev.mysql.com/doc/refman/8.4/en/insert-on-duplicate.html
It is possible to use IGNORE with ON DUPLICATE KEY UPDATE in an INSERT statement, but this may not behave as you expect when inserting multiple rows into a table that has multiple unique keys. If you specify an ON DUPLICATE KEY UPDATE clause and a ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbinterpretedcode.html
NdbInterpretedCode::load_const_null() Description This method is used to load a NULL value into a register. Signature int load_const_null ( Uint32 RegDest ) Parameters This method takes a single parameter, the register into which to place the NULL.
https://dev.mysql.com/doc/heatwave/en/mys-hw-airportdb-quickstart.html
The MySQL HeatWave airportdb Quickstart shows how to import data into the DB System using the MySQL Shell Dump Load utility, loading data into MySQL HeatWave Cluster using Auto Parallel Load, and running queries. This quickstart contains the ...For ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
After loading data from Object Storage into Lakehouse, you can start running AutoML routines. MySQL HeatWave AutoML commands operate on data loaded into MySQL HeatWave. Load the external file into MySQL HeatWave and create an external Lakehouse ...