MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 31 to 40 of 124 total results

13.8 Choosing the Right Type for a Column

https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html

For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. Of the types that represent all the required ...

14.4.2 Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html

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

15.1.20.5 FOREIGN KEY Constraints

https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html

MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...

Chapter 13 Data Types

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

MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...

13.2.8 Conversion Between Date and Time Types

https://dev.mysql.com/doc/refman/8.0/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 ...

13.2.2 The DATE, DATETIME, and TIMESTAMP Types

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

This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME ...

15.8.2 EXPLAIN Statement

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

{EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name ...

17.20.6.1 Adapting an Existing MySQL Schema for the InnoDB memcached Plugin

https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html

Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...

15.2.7 INSERT Statement

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

INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | TABLE table_name | VALUES ...

14.17.5 Functions That Return JSON Value Attributes

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

The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...

Displaying 31 to 40 of 124 total results