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” ...
