Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/mysql-x-expressions-ebnf-definitions.html
This section provides a visual reference guide to the grammar for the expression language used in X DevAPI.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/mysql-x-expressions-ebnf-definitions.html
This section provides a visual reference guide to the grammar for the expression language used in X DevAPI.
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
If there are precision issues, consider casting to a double or float type, or using a generic floating-point data type for the key. Error number: 1091; Symbol: HW_ER_UNSUPPORTED_GBY_ON_FIXED_PRECISION Message: GROUP BY on fixed precision floating ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manaully and specifying the files to load into the table, you specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement to load the data from the files into the table. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
mysql> CREATE TABLE `iris_train` ( `sepal length` float DEFAULT NULL, `sepal width` float DEFAULT NULL, `petal length` float DEFAULT NULL, `petal width` float DEFAULT NULL, `class` varchar(16) DEFAULT NULL); Insert the training data into the table.
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html
MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
row *************************** Level: Note Code: 1003 Message: /* select#1 */ select `test`.`t`.`ti` AS `ti` from `test`.`t` where (`test`.`t`.`ti` = 255) 1 row in set (0.00 sec) Floating- or fixed-point value. If the constant is one of the decimal ... Comparisons between constants and column values in which the constant value is out of range or of the wrong type with respect to the column type are now handled once during query optimization rather row-by-row than during ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-migration.html
InnoDB data and log files are binary-compatible on all platforms having the same floating-point number format. If the floating-point formats differ but you have not used FLOAT or DOUBLE data types in your tables, then the procedure is the same: ...
https://dev.mysql.com/doc/refman/8.4/en/no-matching-rows.html
If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you cannot use equality (=) comparisons. This problem is common in most computer languages because not all floating-point values can be stored with exact precision. In ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
UNSIGNED is deprecated for columns of type FLOAT, DOUBLE, and DECIMAL (and any synonyms) and you should expect support for it to be removed in a future version of MySQL. AUTO_INCREMENT for FLOAT and DOUBLE columns is not supported, as of MySQL 8.4.0. MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...