https://dev.mysql.com/cast-functions.html
This is actually FLOAT if REAL_AS_FLOAT SQL mode is enabled; otherwise the result is of type DOUBLE. Table 12.14 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() ...
https://dev.mysql.com/mysqldump-delimited-text.html
Suppose that you want mysqldump to quote column values within double quotation marks. To do so, specify double quote as the value for the --fields-enclosed-by option. For example, on Unix, you can quote the double quote like this: ... This section ...
https://dev.mysql.com/replication-features-differing-tables.html
Between any of the decimal types DECIMAL, FLOAT, DOUBLE, and NUMERIC. FLOAT to DOUBLE is a non-lossy conversion; DOUBLE to FLOAT can only be handled lossily. Source and target tables for replication do not have to be identical. A table on the ...
https://dev.mysql.com/known-issues.html
Numeric calculations are done with BIGINT or DOUBLE (both are normally 64 bits long). The general rule is that bit functions are performed with BIGINT precision, IF() and ELT() with BIGINT or DOUBLE precision, and the rest with DOUBLE precision.
https://dev.mysql.com/views-table.html
For example, you might use the ANSI SQL mode to ensure MySQL correctly interprets the standard SQL concatenation operator, the double bar (||), in your queries. You must have the SHOW VIEW privilege to access this table. The VIEWS table has these ...
https://dev.mysql.com/numeric-type-attributes.html
As of MySQL 8.0.17, the UNSIGNED attribute is deprecated for columns of type FLOAT, DOUBLE, and DECIMAL (and any synonyms) and will be removed in a future MySQL version. As of MySQL 8.0.17, AUTO_INCREMENT support is deprecated for FLOAT and DOUBLE ... 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/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/storage-requirements.html
If the same column is instead declared to use the ucs2 double-byte character set, the storage requirement is 10 bytes: The length of 'abcd' is eight bytes and the column requires two bytes to store lengths because the maximum length is greater than ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/mysql-cluster-installer-using.html
Navigate to the NDB Cluster bin directory in a file browser (such as Windows Explorer on Windows, or Konqueror, Dolphin, or Nautilus on Linux) and activate (usually by double-clicking) the ndb_setup.py file icon. The NDB Cluster Auto-Installer ...
https://dev.mysql.com/comparison-operators.html
If at least one argument is double precision, they are compared as double-precision values. Whether a value is not within a range of values !=, <> Not equal operator NOT IN() Whether a value is not within a set of values NOT LIKE Negation of simple ...
