Search Results
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
The capabilities of your command processor dictate your choices for whether you can use single or double quotation marks and the syntax for escaping quote characters. For example, if your command processor supports quoting with single or double ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
If the constant is one of the decimal types (such as DECIMAL, REAL, DOUBLE, or FLOAT) and has a nonzero decimal portion, it cannot be equal; fold accordingly. FLOAT(m,n) or DOUBLE(m,n) values compared with constants are handled as follows: If the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
Values of a generated column are computed from an expression included in the column definition. Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
Specify the search words within a double-quoted string immediately before the @distance operator, for example, MATCH(col1) AGAINST('"word1 word2 word3" @8' IN BOOLEAN MODE) > < These two operators are used to change a word's contribution to the ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/ldap-pluggable-authentication.html
Note Under the following combination of conditions, the actual wait time of the authentication_ldap_sasl_connect_timeout setting doubles because (internally) the server must invoke the TCP connection twice: The LDAP server is offline. To quote a ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
On Windows, specify backslashes in path names as forward slashes or doubled backslashes. For example, many programs can export data in comma-separated values (CSV) format, such that lines have fields separated by commas and enclosed within double ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
The package is located inside a disk image (.dmg) file that you first need to mount by double-clicking its icon in the Finder. Double-click the file to mount the disk image and see its contents. Note Before proceeding with the installation, be sure ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/number-literals.html
The FLOAT and DOUBLE data types are floating-point types and calculations are approximate. In MySQL, types that are synonymous with FLOAT or DOUBLE are DOUBLE PRECISION and REAL. Number literals include exact-value (integer and DECIMAL) literals ...