Search Results
https://dev.mysql.com/doc/mysql-ai/9.7/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.7/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/9.7/en/innodb-standard-monitor.html
The contents include the statement that failed as well as information about the constraint that failed and the referenced and referencing tables. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...
https://dev.mysql.com/doc/refman/9.7/en/order-by-optimization.html
Whether the optimizer actually does so depends on whether reading the index is more efficient than a table scan if columns not in the index must also be read. In that case, scanning an entire index and looking up table rows to find columns not in ...
MySQL 9.7 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/9.7/en/replication-rbr-safe-unsafe.html
Trigger or stored program updates a table having an AUTO_INCREMENT column. In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. ON ...
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 ...
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. In such cases, the primary key is usually a composite key made up of the primary keys from the two original tables. A non-identifying relationship: ...Click on the appropriate tool for the type of relationship you wish to ...
https://dev.mysql.com/doc/refman/9.7/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. The ...To ...
https://dev.mysql.com/doc/refman/9.7/en/bug-reports.html
If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. This is a very easy way to get the definition of any table in a database. You should also include the output ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/9.7/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...