https://dev.mysql.com/gis-point-property-functions.html
These functions are available for obtaining point properties: ST_Latitude(p [, new_latitude_val]) With a single argument representing a valid Point object p that has a geographic spatial reference system (SRS), ST_Latitude() returns the latitude ...
https://dev.mysql.com/identifiers.html
The identifier quote character is the backtick (`): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is enabled, it is also permissible to quote identifiers within double quotation marks: mysql> CREATE TABLE "test" ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/precision-math-examples.html
Consider these statements: mysql> CREATE TABLE t (i INT, d DECIMAL, f FLOAT); mysql> INSERT INTO t VALUES(1,1,1); mysql> CREATE TABLE y SELECT AVG(i), AVG(d), AVG(f) FROM t; The result is a double only for the floating-point argument. This section ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/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 ...
https://dev.mysql.com/optimizer-statistics.html
Value 2: A double representing the cumulative frequency for the value. Value 3: A double representing the cumulative frequency for the value. The value is one of int, uint (unsigned integer), double, decimal, datetime, or string (includes character ... The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution ...
https://dev.mysql.com/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/osx-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/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 ...