Search Results
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
(Although you can write an ON DELETE or ON UPDATE clause as part of the REFERENCES clause, it is also ignored.) This syntax creates a column; it does not create any sort of index or key. row *************************** Table: shirt Create Table: ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
ARRAY is not supported except when used to create a multi-valued index in one of these statements, in which case it is required. Note CONVERT(), unlike CAST(), does not support multi-valued index creation or the ARRAY keyword. Other Uses for Cast ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE TABLESPACE. Only undo tablespaces created using CREATE UNDO TABLESPACE syntax can be dropped. Similar to the system tablespace, ...The ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
Creating a FULLTEXT Index that uses the MeCab Parser To create a FULLTEXT index that uses the mecab parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. For a stopword list applicable to Japanese, you must create your ... 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/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/fulltext-stopwords.html
The following example demonstrates creating and configuring a new global stopword table for InnoDB. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
Stored objects include these object types: Stored procedure: An object created with CREATE PROCEDURE and invoked using the CALL statement. Stored function: An object created with CREATE FUNCTION and used much like a built-in function. Trigger: An ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-generate-embeddings.html
Using this method, you can create vector embedding tables that you can use to perform similarity searches using the DISTANCE() function, without setting up a vector store. To learn how to create vector embeddings for unstructured data, see Section ... This section describes how to generate vector embeddings using the ML_EMBED_ROW ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates.html
This section provides an overview of creating and modifying DBDoc Model Reporting templates, as used by MySQL Workbench. It is these output files, typically HTML or text, that are then viewed by the user. The MySQL Workbench DBDoc Model Reporting ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-linux.html
mkdir ~/freetds to create a directory - within the users home directory. Many distributions ship older versions of FreeTDS, so it may need to be installed separately. Additionally, the FreeTDS version provided by distributions may also be compiled ...