Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/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/mysql-ai/9.5/en/mys-mysqlai-ml-generate.html
The ML_GENERATE routine uses the specified large language model (LLM) to generate text-based content as a response for the given natural-language query. It can include the following parameters: task: specifies the task expected from the LLM.
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-markers.html
These markers can be used in any template, including custom templates. Using the table The table shows which variables are defined in which sections. The variable should be used in its correct section or its value will not be displayed. If a ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-results.html
The following figure shows the selection of JSON as the export type from within the Export Resultset window. The import icon opens the Table Data Import dialog from which you can select a data file and other options, such as the destination table.
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html
This wizard supports import and export operations using CSV and JSON files, and includes several configuration options (separators, column selection, encoding selection, and more). The wizard can be performed against local or remotely connected ...
https://dev.mysql.com/doc/workbench/en/wb-audit-inspector.html
On Windows: INSTALL PLUGIN audit_log SONAME 'audit_log.dll' On Linux and macOS: INSTALL PLUGIN audit_log SONAME 'audit_log.so' After the plugin is installed, start MySQL Workbench and select the Administration tab in the navigator. To generate the ... MySQL Workbench offers a graphical interface to MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-basic-add-table.html
Pressing Tab or Enter while the cursor is in the table name field selects the Columns tab of the table editor and creates a default column named idinvoice. Pressing Tab or Enter again sets the focus on the Datatype list with INT selected. The tools ...
https://dev.mysql.com/doc/workbench/en/wb-creating-eer-diagram.html
To add a table to the canvas, select the Catalog tab in the middle panel on the right side of the application to display any schemas that appear in the MySQL Model tab. While a table is selected, you can use the Properties window to change a table's ... To create an EER diagram for the sakila database, first add an EER diagram by double-clicking the Add Diagram icon in the EER Diagrams panel to create and open a new EER Diagram ...
https://dev.mysql.com/doc/workbench/en/wb-design-table-templates.html
From the SQL editor, select Create Table Like from the Tables context menu, as shown in the next figure. Figure 9.66 Table Templates Manager To open an existing template from the SQL editor, hover over the Create Table Like context menu and select ... Define table templates with commonly used columns and settings to create new tables from either a live connection or while creating an EER ...
https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-create-connection.html
On Microsoft Windows, select the appropriate MySQL service for the MySQL connection, as shown in the figure that follows. For this example, select the check box and click Next to continue. This tutorial adds a new connection that can be either an ...