Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-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/connector-j/en/connector-j-installing-source.html
The following third-party libraries: JUnit 5.12.2 (see installation and download information in the JUnit 5 User Guide). The latest release of the Connector/J 9.7 series is on the release/9.7 branch; use the following command to check it out: $> git ... Caution You need to install Connector/J from source only if you want to build a customized version of Connector/J or if you are interested in helping us test our new ...
https://dev.mysql.com/doc/refman/9.7/en/bug-reports.html
To discuss problems with other users, you can use the MySQL Community Slack. If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. The information helps us create a ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/9.7/en/enterprise-encryption-usage.html
They are good for encrypting small amounts of data and creating and verifying signatures. The digest type in these functions refers to the algorithm that is used to sign the data, not the algorithm that was used to create the original input for the ... To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to ...
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/refman/9.7/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...
https://dev.mysql.com/doc/refman/9.7/en/show-engine.html
For rwlocks, the Name field reports the source file where the rwlock is implemented, and the line number in the file where the rwlock is created. The remaining rows from the output of SHOW ENGINE NDB STATUS which are most likely to prove useful in ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/connectors/en/connector-j-client-authentication.html
The server may want to authenticate a client and require the client to provide an SSL certificate to it, which it verifies against its known certificate authorities or performs additional checks on the client identity if needed (see CREATE USER ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-document-store.html
A non-root account can be used as long as the account has privileges to create new databases. Execute the world_x.sql script to create the database structure and insert the data as follows: mysql> SOURCE /temp/world_x.sql; Replace /temp/ with the ...