Search Results
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-full-text-plugins.html
Table 4.3 Full-Text Parser Token Types Token Value Meaning FT_TOKEN_EOF End of data FT_TOKEN_WORD A regular word FT_TOKEN_LEFT_PAREN The beginning of a group or subexpression FT_TOKEN_RIGHT_PAREN The end of a group or subexpression FT_TOKEN_STOPWORD ... MySQL supports server-side full-text parser plugins with MyISAM and ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-classification-overview.html
mysql> CREATE DATABASE classification_data; mysql> USE classification_data; Create the table to insert the sample data into. This topic describes how to prepare the data to use for a classification machine learning model. The classification ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-predictions-ml-predict-row.html
The column names must match the feature column names in the trained table. Generating Predictions on One or More Rows of Data Another way to generate predictions is to create a JSON_OBJECT with specified columns and labels, and then generate ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-data-overview.html
Labeled Data Example A table of data for bank customers can be a labeled dataset. The feature columns in the table have data related to job, marital status, education, and city of residence. You can use some of the data in this table to train a ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-preparing-a-recommendation-model.html
mysql> CREATE DATABASE recommendation_data; mysql> USE recommendation_data; Create the table to insert the sample data into. mysql> CREATE TABLE training_dataset ( user_id VARCHAR(3), item_id VARCHAR(3), rating DECIMAL(3, 1), PRIMARY KEY (user_id, ... This topic describes how to prepare the data to use for a recommendation machine learning model using explicit ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-regression-prepare.html
mysql> CREATE DATABASE regression_data; mysql> USE regression_data; Create the table to insert the sample data into. mysql> CREATE TABLE house_price_training ( id INT PRIMARY KEY, house_size INT, address TEXT, state TEXT, price INT ); Insert the ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-vector-store-overview.html
About Accelerated Processing of Queries on Vector-Based Tables GenAI lets you run queries on tables that contain vector embeddings at an accelerated pace by offloading them to the MySQL AI Engine (AI engine). However, for query offload to be ...
https://dev.mysql.com/doc/workbench/en/wb-foreign-key-relationships.html
MySQL Workbench enables you to add a foreign key from within the table editor or from within an EER diagram by using the relationship tools on the vertical toolbar. To add a foreign key using the table editor, see Section 8.1.10.4, “Foreign Keys ... Foreign key constraints are supported for the InnoDB storage engine ...
https://dev.mysql.com/doc/workbench/en/wb-grt-data-organization.html
Workbench model data, such as diagrams, schemas, and tables, is stored in a hierarchy of objects that can be accessed by any plugin. Main Nodes in the Application Object Tree Table C.1 The main nodes in the Application Object Tree Node Description ... The Generic RunTime (GRT) is the internal system used by MySQL Workbench to hold model document ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...