PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/year.html
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 as YEAR(4) with an explicit display width. Note As of MySQL 8.0.19, the YEAR(4) data type with ...
https://dev.mysql.com/doc/refman/8.0/en/two-digit-years.html
Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no guarantee. MySQL ...
https://dev.mysql.com/doc/refman/8.0/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.0/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. Each temporal type has a range of valid values, as well as a “zero” value that may be used when you specify an invalid value that MySQL ...