Rechercher dans le manuel MySQL
Search Results
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 ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-double-p-2.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
