Search Results
https://dev.mysql.com/doc/refman/9.7/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-hash.html
In addition, you most likely want to follow this with PARTITIONS num, where num is a positive integer representing the number of partitions into which the table is to be divided. You should also keep in mind that this expression is evaluated each ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysqlrouter.html
mysqlrouter Option Summaries mysqlrouter Option Descriptions MySQL Router accepts command line options that are passed into mysqlrouter to affect its behavior, or to bootstrap router based on an InnoDB Cluster. This is because validate_password can ...When starting Router, you can optionally use --config to pass in the main configuration file's location (otherwise the default location is used) and --extra-config for an additional configuration ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-real-escape-string-quote.html
The string in the from argument is encoded to produce an escaped SQL string, taking into account the current character set of the connection. Return Values The length of the encoded string that is placed into the to argument, not including the ...
https://dev.mysql.com/doc/mysql-ai/9.7/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.7/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.7/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/ndbapi/en/ndb-ndboperation.html
When using insertTuple(), you may also define the search key with setValue(). NdbOperation::insertTuple() Description This method defines the NdbOperation to be an INSERT operation. NdbOperation::read_attr() Description Read an attribute identified ...Beginning with NDB 8.0.30, NdbOperation supports an interpreted code API similar to that implemented by ...
https://dev.mysql.com/doc/refman/9.7/en/char.html
For those cases where trailing pad characters are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting into the column values that differ only in number of trailing pad characters results in a ...For ... The CHAR and VARCHAR types are similar, but differ in the way they are stored and ...
https://dev.mysql.com/doc/refman/9.7/en/json-validation-functions.html
As before, you can see this by attempting to insert the value into the geo table, then issuing SHOW WARNINGS afterwards: mysql> INSERT INTO geo VALUES(@point3); ERROR 3819 (HY000): Check constraint 'geo_chk_1' is violated. MySQL supports validation ...