MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 18 of 18 total results

« Previous
1
2
Next »

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

Such implicit casts are now performed between temporal types (DATE, DATETIME, TIMESTAMP, TIME) and numeric types (SMALLINT, TINYINT, MEDIUMINT, INT/INTEGER, BIGINT; DECIMAL/NUMERIC; FLOAT, DOUBLE, REAL; BIT) whenever they are compared using any of ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...

15.2.9 LOAD DATA Statement

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

For TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT, the field widths are 4, 6, 8, 11, and 20, respectively, no matter what the declared display width is. The file can be read from the server host or the client host, depending on whether the LOCAL ...

13.8 Choosing the Right Type for a Column

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

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

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

14.5 Flow Control Functions

https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html

Otherwise, the result is an integer type (with one exception): If all integer types are all signed or all unsigned, the result is the same sign and the precision is the highest of all specified integer types (that is, TINYINT, SMALLINT, MEDIUMINT, ...The second syntax returns the result for the first condition that is ...

1.6.1 MySQL Extensions to Standard SQL

https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html

Data types The MEDIUMINT, SET, and ENUM data types, and the various BLOB and TEXT data types. MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not ...

10.8.5 Estimating Query Performance

https://dev.mysql.com/doc/refman/8.0/en/estimating-performance.html

For a 500,000-row table with a key value length of three bytes (the size of MEDIUMINT), the formula indicates log(500,000)/log(1024/3*2/(3+4)) + 1 = 4 seeks. In most cases, you can estimate query performance by counting disk seeks. For small ...

17.6.1.5 Converting Tables from MyISAM to InnoDB

https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html

For the ranges of the different integer types, see Section 13.1.2, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT”. If you have MyISAM tables that you want to convert to InnoDB for better reliability and ...