Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/devapi-users-working-with-relational-tables.html
The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are similar to running INSERT and SELECT statements on a table with an SQL client. The X DevAPI SQL CRUD functions allow you to work ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collections-as-relational-tables.html
The following example shows how to insert a JSON document string into the doc field. # Get the customers collection as a table customers = db.get_collection_as_table('customers') customers.insert('doc').values('{"_id":"001", "name": "Ana", ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/creating-documents.html
// Create a new collection 'my_collection' var myColl = db.createCollection('my_collection'); // Insert JSON data directly myColl.add({_id: '8901', name: 'Mats', age: 21}).execute(); // Inserting several docs at once myColl.add([ {_id: '8902', name: ... Once a collection has been created, it can store JSON ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/devapi-users-working-with-relational-tables.html
The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are similar to running INSERT and SELECT statements on a table with an SQL client. The X DevAPI SQL CRUD functions allow you to work ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
The following list contains all current MySQL HeatWave errors in numerical order. The entry for each error contains the error number, name (symbol), description, and suggested workaround for the condition that gave rise to the error. Error number: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using MySQL HeatWave GenAI: Before You Begin Generate Content Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI routine. Vector embeddings are a numerical representation of the text that capture the semantics of the data and relationships to other data. You ...
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.5.0, you can use hybrid search, which combines semantic search and keyword-based search to effectively retrieve ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
When you run MySQL HeatWave Chat, it automatically loads the default LLM. By default, MySQL HeatWave Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
It can scale horizontally by adding more servers to the cluster, or ', 'vertically by upgrading the hardware.' ) ); mysql> INSERT INTO input_table (Input) VALUES( CONCAT( 'Artificial Intelligence or AI refers to the simulation of human intelligence ... The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...