Search Results
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-nl-sql.html
GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This feature collects information on the schemas, tables, and columns that you have access to, and then uses a Large ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The second statement SELECT JSON_OBJECT("Task result", "Finished...") into @task_result generates an output that is stored in the reserved session variable @task_result. You can optionally use the reserved session variable @task_result to add a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
Run the Chat To run MySQL HeatWave Chat, perform the following steps: To delete previous chat output and state, if any, reset the @chat_options variable: mysql> SET @chat_options=NULL; Note Ensure that you use the name @chat_options for the variable. The HEATWAVE_CHAT routine reserves this variable for specifying and saving various chat parameter ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
Optionally, set the value of the session variable, which sets the model handle to this same value. mysql> CALL sys.ML_TRAIN('ml_data.iris_train', 'class', JSON_OBJECT('task', 'classification'), @model); When the training operation finishes, the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-score.html
model_handle: Specifies the model handle or a session variable containing the model handle. Query the score with the session variable for the ML_SCORE routine. ML_SCORE scores a model by generating predictions using the feature columns in a labeled ...
https://dev.mysql.com/doc/refman/9.7/en/column-count-limit.html
If a row containing variable-length columns exceeds the InnoDB maximum row size, InnoDB selects variable-length columns for external off-page storage until the row fits within the InnoDB row size limit. The amount of data stored locally for ... This ...
https://dev.mysql.com/doc/refman/9.7/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-genai-run-chat.html
To delete previous chat output and state, if any, reset the @chat_options variable: mysql> SET @chat_options=NULL; Note Ensure that you use the name @chat_options for the variable. The HEATWAVE_CHAT routine reserves this variable for specifying and ... When you run GenAI Chat, it automatically loads the llama3.2-3b-instruct-v1 ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-mysqlai-ml-score.html
model_handle: Specifies the model handle or a session variable containing the model handle. Query the score with the session variable for the ML_SCORE routine. ML_SCORE scores a model by generating predictions using the feature columns in a labeled ...
https://dev.mysql.com/doc/workbench/en/wb-grt-data-organization.html
The Generic RunTime (GRT) is the internal system used by MySQL Workbench to hold model document data. It is also the mechanism by which Workbench can interact with Modules and Plugins. Workbench model data, such as diagrams, schemas, and tables, is ...