Search Results
https://dev.mysql.com/doc/refman/9.7/en/enum.html
For example, this CREATE TABLE statement does not work because the CONCAT function cannot be used to construct an enumeration value: CREATE TABLE sizes ( size ENUM('small', CONCAT('med','ium'), 'large') ); You also cannot employ a user variable as ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-preparing-a-recommendation-model.html
mysql> CREATE TABLE training_dataset ( user_id VARCHAR(3), item_id VARCHAR(3), rating DECIMAL(3, 1), PRIMARY KEY (user_id, item_id) ); Insert the sample data to train into the table. mysql> CREATE TABLE testing_dataset ( user_id VARCHAR(3), item_id ...To ensure reliable predictions, you should create an additional validation ... This topic describes how to prepare the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-overview-steps.html
The current Workbench MySQL connections will be available here, or you can choose Manage DB Connections to create a new connection. "Schema Name Mapping Method" options while migrating Microsoft SQL Server: Keep schemas as they are: ... This example ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-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 MySQL HeatWave GenAI ...
https://dev.mysql.com/doc/refman/9.7/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. Explicit selection of ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-js-programs.html
A JavaScript stored program created on a server without the component installed is not checked for validity. This means that, when a CREATE FUNCTION or CREATE PROCEDURE statement without USING, and which contains invalid JavaScript code, is executed ...If the replica has the MLE component installed, an error is raised when the replica attempts to execute such a statement, leading to a break in ...
https://dev.mysql.com/doc/refman/9.7/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/refman/9.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-enterprise-backup-online-backup.html
It is scheduled using the operating system user that is scheduling the backup, which is typically the MySQL user. A new sub-folder is created for each backup, named with its timestamp. Each incremental backup also creates its own timestamped ...