MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 20 of 30 total results

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

For example, given a table t with a TINYINT UNSIGNED column c, the optimizer can rewrite a condition such as WHERE c < 256 to WHERE 1 (and optimize the condition away altogether), or WHERE c >= 255 to WHERE c = 255. Such implicit casts are now ...

13.1.1 Numeric Data Type Syntax

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

For integer data types, M indicates the minimum display width. Display width is unrelated to the range of values a type can store, as described in Section 13.1.6, “Numeric Type Attributes”. For floating-point and fixed-point data types, M is ...

30.4.5.20 The version_major() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-version-major.html

15.7.7.42 SHOW WARNINGS Statement

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

mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...

30.4.5.21 The version_minor() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-version-minor.html

30.4.5.22 The version_patch() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-version-patch.html

This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +--------------+---------------------+ | VERSION() | sys.version_patch() | +--------------+---------------------+ | ...

10.2.1.1 WHERE Clause Optimization

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

This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...

26.2.3 COLUMNS Partitioning

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

The permitted data types are shown in the following list: All integer types: TINYINT, SMALLINT, MEDIUMINT, INT (INTEGER), and BIGINT. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS ...

25.5.23 ndb_restore — Restore an NDB Cluster Backup

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html

The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin directory. This program reads the files created as a result of the backup and inserts the stored ...

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

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

For example, a BIGINT column (eight bytes) can be stored as a TINYINT column (one byte) if all its values are in the range from -128 to 127. When the table is used later, the server reads into memory the information needed to decompress columns.

Displaying 11 to 20 of 30 total results