Search Results
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance Schema Notes sys Schema Notes Thread Pool Notes Functionality Added or Changed Bugs Fixed C API Notes The asynchronous interface used ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/setting-up-innodb-cluster-and-mysql-router.html
In the following example, we complete the following tasks using a sandbox deployment with AdminAPI to deploy an InnoDB Cluster with MySQL Router. Deploying and using local sandbox instances of MySQL allows you to test out the functionality locally, ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-rag.html
The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your queries. For context retrieval, the ML_RAG routine uses the name of the embedding model used to embed the input query to find relevant ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-vector-store-overview.html
This section describes the Vector Store functionality available with GenAI. About Vector Store A vector store is a relational database that lets you load unstructured data. It automatically parses unstructured data formats, which include PDF ...
https://dev.mysql.com/doc/workbench/en/wb-generating-sql.html
MySQL Workbench can be used to generate SQL, most typically as either INSERT statements or SELECT statements. The following common methods are for generating SQL statements in MySQL Workbench. Note All of the MySQL Workbench Export options include ...