Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
An error occurs if the value starts and ends with double quotes but is not a valid JSON string literal. The functions in this section modify JSON values and return the result. JSON_ARRAY_APPEND(json_doc, path, val[, path, val] ...) Appends values ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
The timeout is applied with approximately 100 ms resolution, starting with a 100 ms delay; for each subsequent attempt, the length of this period is doubled until it reaches ConnectBackoffMaxTime milliseconds, up to a maximum of 100000 ms (100s).
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-import.html
The CSV input worker allocates buffer that is doubled in size. ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. ndb_import requires a connection to an NDB management server ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
The username, password, and token file path must be enclosed in single or double quotes. Escape single quotes, double quotes, and back slashes if present in the username or password. MySQL Configurator supports GUI (default) and CLI (by passing in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
The use of the AUTO_INCREMENT modifier with FLOAT and DOUBLE columns in CREATE TABLE and ALTER TABLE statements was deprecated in MySQL 8.0; support for it is removed altogether in MySQL 8.4, where it raises ER_WRONG_FIELD_SPEC (Incorrect column ...
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. In some cases, changing the FLOAT to a DOUBLE fixes this. If you have a complicated query that uses many tables but that returns ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
If an arithmetic operator has no type-determining context, the derived type for any parameters involved is DOUBLE PRECISION. The derived type is DOUBLE and the actual type is any numeric type. PREPARE stmt_name FROM preparable_stmt The PREPARE ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
Multiple-line string literals enclosed within either single quote (') or double quote (") characters. timestamp is a DOUBLE rather than BIGINT because its value includes a microseconds part. The MySQL server maintains many system variables that ...