Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
If set, the routine searches for vector store tables in this schema. This parameter cannot be used in combination with the tables parameter. vector_store_columns: optional parameter which specifies column names for finding relevant vector and ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locking-reads.html
However, FOR SHARE supports OF table_name, NOWAIT, and SKIP LOCKED options. FOR SHARE statements do not acquire read locks on MySQL grant tables. FOR UPDATE requires the SELECT privilege and at least one of the DELETE, LOCK TABLES, or UPDATE ... If ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. To embed multiple rows of text stored in a table in a single run, you can even run a batch query. Using this method, you can create vector embedding ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-chat.html
If set, the routine searches for vector store tables in this schema. This parameter cannot be used in combination with the tables parameter. vector_store_columns: optional parameter which specifies column names for finding relevant vector and ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
In terms of table content, conversion from utf8mb3 to utf8mb4 presents no problems: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, same length. In terms of table structure, these are ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
https://dev.mysql.com/doc/refman/8.4/en/engine-condition-pushdown-optimization.html
Joins are not directly supported; conditions involving multiple tables are pushed separately where possible. Previously, engine condition pushdown was limited to terms referring to column values from the same table to which the condition was being ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...So, ...
https://dev.mysql.com/doc/workbench/en/wb-eer-color-key.html
Color connection lines within EER diagrams provide quick visual information about how the tables in your model relate. The following table defines the meaning of each color and indicates how you can open the underlying table information from your ...Existing connection lines are highlighted when you use a pointer device to hover on different database ...