Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-types.html
Data type descriptions use these conventions: For integer types, M indicates the maximum display width. MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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.4/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 ...