https://dev.mysql.com/two-digit-years.html
For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR results in 0000 rather than 2000. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form ...
https://dev.mysql.com/update.html
The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause ...
https://dev.mysql.com/user-variables.html
User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. To assign a hexadecimal or bit value as a number to a user variable, use it in numeric context. You can store a value in a ...
https://dev.mysql.com/using-date.html
For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice versa. You should use this format in UPDATE expressions and in the WHERE ...
https://dev.mysql.com/using-innodb-tables.html
With so many constraints, often there is not an obvious set of columns to use as a primary key, so you create a new column with a numeric ID to serve as all or part of the primary key. To create an InnoDB table, use the CREATE TABLE statement.
https://dev.mysql.com/using-system-variables.html
When you use a startup option to set a variable that takes a numeric value, the value can be given with a suffix of K, M, or G (either uppercase or lowercase) to indicate a multiplier of 1024, 10242 or 10243; that is, units of kilobytes, megabytes, ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/validate-password.html
MEDIUM policy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character. The validate_password component serves to improve security by ...
https://dev.mysql.com/variables-info-table.html
Both are 0 for variables that have no such values (that is, variables that are not numeric). The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The ...
https://dev.mysql.com/xml-functions.html
Check all user-submitted data for type; reject or convert data that is of the wrong type Test numeric data for out of range values; truncate, round, or reject values that are out of range. Table 12.15 XML Functions Name Description ExtractValue() ...
https://dev.mysql.com/year.html
The result of inserting a numeric 0 has a display value of 0000 and an internal value of 0000. The YEAR type is a 1-byte type used to represent year values. It can be declared as YEAR with an implicit display width of 4 characters, or equivalently ...
