Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table manually. Create External Table Manually Example To demonstrate how to create an external table manually, the following example specifies a ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | +--------+------------------+ Example 2. Consider these statements: mysql> CREATE TABLE t (i ... This section provides some examples that show precision math query results in ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-troubleshooting.html
3.14.6: Updating a table that contains a primary key that is either FLOAT or compound primary key that uses FLOAT fails to update the table and raises an exception. 3.14.6: Updating a table that contains a primary key that is either FLOAT or ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate-table.html
temperature: specifies a non-negative float that tunes the degree of randomness in generation. Possible values are float values between: 0 and 5 For the MySQL HeatWave In-Database LLMs. Possible values are: For Cohere LLMs, float values between 0 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
temperature: specifies a non-negative float that tunes the degree of randomness in generation. Possible values are float values between: 0 and 5 for the MySQL HeatWave In-Database LLMs. Possible values are: For Cohere LLMs, float values between 0 ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
16.6: Updating a table that contains a primary key that is either FLOAT or compound primary key that uses FLOAT fails to update the table and raises an exception. 16.6: Updating a table that contains a primary key that is either FLOAT or compound ...
https://dev.mysql.com/doc/refman/8.4/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. For example, 2.34 is an exact-value (fixed-point) number, whereas 2.34E0 is an approximate-value (floating-point) number. The FLOAT ...Numbers may be preceded by - or + to indicate a negative or positive value, ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbrecattr.html
NdbRecAttr Class Overview ~NdbRecAttr() NdbRecAttr::aRef() NdbRecAttr::char_value() NdbRecAttr::clone() NdbRecAttr::double_value() NdbRecAttr::float_value() NdbRecAttr::get_size_in_bytes() NdbRecAttr::getColumn() NdbRecAttr::getType() ...An ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-numbers.html
Approximate-value data types and numeric literals are handled as floating-point numbers. For example, 2.34 is an exact-value (fixed-point) number, whereas 2.34E0 is an approximate-value (floating-point) number. The FLOAT and DOUBLE data types are ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1427; Symbol: ER_M_BIGGER_THAN_D; SQLSTATE: 42000 Message: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s'). Error number: 3856; Symbol: ER_WARN_DEPRECATED_FLOAT_AUTO_INCREMENT; SQLSTATE: HY000 Message: ... The ...