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
Displaying 151 to 160
of 163 total results
- « Previous
- 14
- 15
- 16
- 17
- Next »
https://dev.mysql.com/precision-math-expressions.html
The expression is exact and is evaluated using integer arithmetic and has a precision the same as BIGINT (64 bits). If strict mode is enabled, inserts and updates involving division by zero are prohibited, and an error occurs. With precision math, ...
https://dev.mysql.com/regexp.html
You should keep in mind that positional indexes are based on 16-bit chunks and not on code points. This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special ...
https://dev.mysql.com/replication-mode-change-online-verify-transactions.html
There are several possible ways to wait for transactions to replicate: The simplest method, which works regardless of your topology but relies on timing is as follows: if you are sure that the slave never lags more than N seconds, just wait for a ...
https://dev.mysql.com/security-against-attack.html
To make FILE-privilege operations a bit safer, files generated with SELECT ... When you connect to a MySQL server, you should use a password. All other information is transferred as text, and can be read by anyone who is able to watch the ...
https://dev.mysql.com/server-status-variables.html
The value is a bitmask; bits are defined in the openssl/ssl.h header file: # define SSL_VERIFY_NONE 0x00 # define SSL_VERIFY_PEER 0x01 # define SSL_VERIFY_FAIL_IF_NO_PEER_CERT 0x02 # define SSL_VERIFY_CLIENT_ONCE 0x04 SSL_VERIFY_PEER indicates that ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/spatial-geojson-functions.html
The srid argument, if given, must be a 32-bit unsigned integer. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...
https://dev.mysql.com/spatial-reference-systems.html
Earth is a bit shorter in its North-South axis than its East-West axis, so a slightly flattened sphere is more correct, but perfect spheres permit faster calculations. A spatial reference system (SRS) for spatial data is a coordinate-based system ...
https://dev.mysql.com/string-type-syntax.html
CHAR(0) is also quite nice when you need a column that can take only two values: A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string). The string data types are CHAR, VARCHAR, ...
https://dev.mysql.com/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/using-date.html
When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, or BETWEEN operators, MySQL normally converts the string to an internal long integer for faster comparison (and also for a bit more “relaxed” ...
Displaying 151 to 160
of 163 total results
- « Previous
- 14
- 15
- 16
- 17
- Next »
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-bit-p-16.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.
