PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/storage-requirements.html
Leftover Digits Number of Bytes 0 0 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 Date and Time Type Storage Requirements For TIME, DATETIME, and TIMESTAMP columns, the storage required for tables created before MySQL 5.6.4 differs from tables created from 5.6.4 ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/9.7/en/show-events.html
Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ALTER EVENT statement that modified the event. This is displayed as a DATETIME value, and ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.5, “Using the Event ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
Partition the table by RANGE COLUMNS, using a DATE or DATETIME column as the partitioning column. A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies ...
https://dev.mysql.com/doc/refman/9.7/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/server-system-variables.html
This is similar to how MySQL treats other temporal types such as DATETIME. For additional information, see Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. BACKUP If the data file was changed during recovery, ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/9.7/en/expressions.html
For the - operator, INTERVAL expr unit is permitted only on the right side, because it makes no sense to subtract a date or datetime value from an interval. This section lists the grammar rules that expressions must follow in MySQL and provides ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
Examples: If you compare a DATETIME to two DATE values, convert the DATE values to DATETIME values. For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
A parameter which is an operand of a temporal operator has type DATETIME if the operator returns a DATETIME, TIME if the operator returns a TIME, and DATE if the operator returns a DATE. PREPARE stmt_name FROM preparable_stmt The PREPARE statement ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-pruning.html
Pruning can also be applied for tables partitioned on a DATE or DATETIME column when the partitioning expression uses the YEAR() or TO_DAYS() function. Important Invalid DATE and DATETIME values referenced in the WHERE condition of a statement ...