Search Results
https://dev.mysql.com/doc/refman/8.4/en/triggers.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on ...For example, rows can be inserted by INSERT or LOAD DATA statements, and an insert trigger activates for each inserted ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. For information about account representation in the user table, see Section 8.2.3, “Grant Tables”. Warning The MySQL user name length limit is hardcoded in MySQL servers and ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-server-compatibility.html
This option modifies the ENGINE= clause of CREATE TABLE statements to specify INNODB for tables that do not already use the InnoDB storage engine. This modifier removes the TABLESPACE clause from GRANT statements, so all tables are created in their ...loadDump command only allows import of dumps created with the ocimds option ... MySQL Server Compatibility 7.1.2 MySQL Server Compatibility MySQL HeatWave on AWS has several ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-overview.html
mysql> CREATE DATABASE classification_data; mysql> USE classification_data; Create the table to insert the sample data into. To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-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, ...To ensure reliable predictions, you should create an additional validation ... This topic describes how to prepare the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-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-aml-classification-overview.html
mysql> CREATE DATABASE classification_data; mysql> USE classification_data; Create the table to insert the sample data into. To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in ...