MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 20 of 107 total results

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 ...

9.5.2 Point-in-Time Recovery Using Event Positions

https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html

The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a point-in-time-recovery. As an example, suppose that around 20:06:00 on March 11, 2020, an SQL statement ...

7.1.15 MySQL Server Time Zone Support

https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html

This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Beginning with MySQL 8.0.19, time ...

14.1 Built-In Function and Operator Reference

https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html

The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...

15.1.15 CREATE INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/create-index.html

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...

28.3.14 The INFORMATION_SCHEMA EVENTS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html

The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.

14.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html

When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...

13.6 Data Type Default Values

https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html

Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...

13.2.6 Fractional Seconds in Time Values

https://dev.mysql.com/doc/refman/8.0/en/fractional-seconds.html

MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...

13.5 The JSON Data Type

https://dev.mysql.com/doc/refman/8.0/en/json.html

The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...

Displaying 11 to 20 of 107 total results