Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-formats.html
The third, compressed format, can be created only with the myisampack utility (see Section 6.6.6, “myisampack — Generate Compressed, Read-Only MyISAM Tables”). When you use CREATE TABLE or ALTER TABLE for a table that has no BLOB or TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the CREATE TABLE statement is supported on Windows for InnoDB tables only, as described in Section 17.6.1.2, “Creating Tables Externally”. For MyISAM and other storage engines, the ...File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir ... The following restrictions apply to use ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Indexes are especially important for queries that reference ...
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.5/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 ...
https://dev.mysql.com/doc/mysql-ai/9.5/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, ...To ensure reliable predictions, you should create an additional validation ... This topic describes how to prepare the ...
https://dev.mysql.com/doc/mysql-ai/9.5/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 ...