PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
To some extent, you can convert a value from one temporal type to another. However, there may be some alteration of the value or loss of information. In all cases, conversion between temporal types is subject to the range of valid values for the ...
https://dev.mysql.com/doc/refman/8.0/en/declare-condition.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
Mogae", "GovernmentForm": "Republic" }, "demographics": { "Population": 1622000, "LifeExpectancy": 39.29999923706055 } } This document shows that the values of keys can be simple data types, such as integers or strings, but can also contain other ...
https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html
mysql> SELECT UNCOMPRESSED_LENGTH(COMPRESS(REPEAT('a',30))); -> 30 VALIDATE_PASSWORD_STRENGTH(str) Given an argument representing a plaintext password, this function returns an integer to indicate how strong the password is, or NULL if the argument ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared library. From MySQL 8.0.30, the functions are provided by a MySQL component ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-format.html
The value is an integer indicating milliseconds since the epoch ('1970-01-01 00:00:00' UTC). Each error log sink (writer) component has a characteristic output format it uses to write messages to its destination, but other factors may influence the ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. It implements the required ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
The difference is due to how the casts between integers and floats/doubles are performed internally by InnoDB (along with related precision and rounding decisions), and how they are performed elsewhere, such as in the MySQL command-line client or ...
https://dev.mysql.com/doc/refman/8.0/en/generated-column-index-optimizations.html
For example, if the generated column expression is f1 + 1, the optimizer does not recognize a match if the query uses 1 + f1, or if f1 + 1 (an integer expression) is compared with a string. For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) ...