Search Results
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Some menu items are not available in the MySQL Workbench Community Edition of this application, and are available only in the MySQL Workbench Commercial Editions. The following submenu items apply to the active model tab, EER diagram tab, or both: ...9.1.1.1.1 The File Menu Use the File menu to open a project, begin a new project, or save a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
In MySQL 8.0, innodb_flush_method was also set automatically by this option, but in MySQL 8.4, this is no longer the case. You should consider using --innodb-dedicated-server only if the MySQL instance resides on a dedicated server where it can use ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
MySQL also supports the JSON Merge Patch format defined in RFC 7396, using the JSON_MERGE_PATCH() function. The MySQL optimizer also looks for compatible indexes on virtual columns that match JSON expressions. MySQL NDB Cluster supports JSON columns ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-supported-models.html
This topic provides the list of languages that MySQL HeatWave GenAI supports and the embedding models as well as large language models (LLMs) that are available in MySQL HeatWave. This topic contains the following sections: Before You Begin View ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system schema, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the CONNECTION_ADMIN privilege (or ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. This enables MySQL to determine that address is functionally dependent on name; that is, address is uniquely ...The ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
For example, it is possible to permit an account to modify any table except those in the mysql system schema. To change the value for the running MySQL instance without having it carry over to subsequent restarts, use the GLOBAL keyword rather than ... It is possible to grant privileges that apply globally if the partial_revokes system variable is ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/myai-installation-clean-cmdline.html
The MySQL AI Installer can also be run in command-line mode, without invoking the installation GUI. Warning MySQL AI might not work or might have performance issues if installed on a system that does not satisfy the minimum requirements. User and ...Install Without Satisfying Minimum Requirements --skip-requirements: Install even if the system does not satisfy the minimum ...
https://dev.mysql.com/doc/refman/8.4/en/connectors-apis.html
MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to MySQL resources using either the classic MySQL protocol or X Protocol. Both Connectors and the APIs enable you to connect and execute ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-byo-embedding-tables.html
For example: mysql> ALTER TABLE demo_minilm_table SECONDARY_LOAD; This accelerates processing of vector distance function used to compare vector embeddings and generate relevant output later in this section. For example: mysql> SET @options = ...