No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/numeric-type-attributes.html
For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift up, from -2147483648 and 2147483647 to 0 and 4294967295. MySQL supports an extension for optionally specifying the display width of ...
https://dev.mysql.com/precision-math-decimal-characteristics.html
D is the number of digits to the right of the decimal point (the scale). Leftover Digits Number of Bytes 0 0 1–2 1 3–4 2 5–6 3 7–9 4 For example, a DECIMAL(18,9) column has nine digits on either side of the decimal point, so the integer part ... This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage format Storage requirements The nonstandard MySQL extension to the upper range of DECIMAL columns The declaration syntax for a DECIMAL column is ...
https://dev.mysql.com/precision-math-expressions.html
(If strict SQL mode is not enabled, truncation for INSERT is permissible.) Handling of a numeric expression depends on what kind of values the expression contains: If any approximate values are present, the expression is approximate and is evaluated ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/replication-gtids-howto.html
Binary logs containing transactions without GTIDs cannot be used on servers where GTIDs are enabled, so backups taken before this point cannot be used with your new configuration. If you use binary logs for anything other than replication, for ...
https://dev.mysql.com/replication-mode-change-online-disable-gtids.html
The only thing that differs is the point at which you wait for logged transactions to replicate. If you use binary logs for anything else than replication, for example to do point in time backup or restore: wait until you do not need the old binary ... This section describes how to disable GTID transactions on servers that are already ...
https://dev.mysql.com/server-options.html
To enable it, specify a value greater than 0; this value also becomes the default timeout for individual synchronization points. For a description of the Debug Sync facility and how to use synchronization points, see MySQL Internals: Test ... When ...
https://dev.mysql.com/source-configuration-options.html
(The default value is 0, which disables Debug Sync.) N becomes the default timeout for individual synchronization points. For a description of the Debug Sync facility and how to use synchronization points, see MySQL Internals: Test Synchronization.
https://dev.mysql.com/spatial-type-overview.html
Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON GEOMETRY can store geometry values of any type. The other single-value types (POINT, LINESTRING, and POLYGON) restrict their values to a particular geometry type.
https://dev.mysql.com/writing-information-schema-plugins.html
The array pointed to by fields_info should contain one element per column of the INFORMATION_SCHEMA plus a terminating element. This section describes how to write a server-side INFORMATION_SCHEMA table plugin. For example code that implements such ...
https://dev.mysql.com/writing-plugins-overview.html
For example, each plugin's general plugin descriptor points to the initialization and deinitialization functions that the server should invoke when it loads and unloads the plugin. These conditions apply to plugin writing: MySQL header files used ...
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-point-p-9.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.
