Search Results
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-2.html
This default value change will impact the following processes: New vector store tables will be created using multilingual-e5-small by default. Retrieval augmented generation (RAG) will search tables created using the default embedding model, ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-privatelink-details.html
PrivateLink Details 6.3.5.1 PrivateLink Details The PrivateLink Details page has the following tabs: Table 6-3 Tabs on the PrivateLink Details Page Name Description Details Details of the PrivateLink. Table 6-4 PrivateLink Details Field Description ...Endpoints (for Egress PrivateLinks only) Details of the connectivity provided by this Egress ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method. getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
For example: SHOW GRANTS FOR 'joe'@'office.example.com'; SHOW GRANTS FOR 'joe'@'home.example.com'; Internally, the server stores privilege information in the grant tables of the mysql system database. The MySQL server reads the contents of these ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
Unless otherwise noted, data previously stored in metadata files is now stored in data dictionary tables. With the removal of .frm files: The 64KB table definition size limit imposed by the .frm file structure is removed. The Information Schema ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. A character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin that supports Japanese are provided for use with ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
Creating a FULLTEXT Index that Uses the ngram Parser To create a FULLTEXT index that uses the ngram parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. The following example demonstrates creating a table with an ngram ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
It registers the function in the mysql.func system table to make it persistent across server restarts. It adds the function to the Performance Schema user_defined_functions table that provides runtime information about installed loadable functions.
https://dev.mysql.com/doc/refman/8.4/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). row ...