MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 121 to 130 of 135 total results

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

For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted numbers in CHAR columns. For integer data types, M indicates the minimum display width. Display width is ...

10.2.1.16 ORDER BY Optimization

https://dev.mysql.com/doc/refman/9.7/en/order-by-optimization.html

For example, if only the first 10 bytes of a CHAR(20) column are indexed, the index cannot distinguish values past the 10th byte and a filesort is needed. Separate the paths by colon characters (:) on Unix and semicolon characters (;) on Windows.

26.2.3 COLUMNS Partitioning

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

The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...

26.2.4 HASH Partitioning

https://dev.mysql.com/doc/refman/9.7/en/partitioning-hash.html

Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...

26.2.4.1 LINEAR HASH Partitioning

https://dev.mysql.com/doc/refman/9.7/en/partitioning-linear-hash.html

MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...

29.12.22.12 The user_defined_functions Table

https://dev.mysql.com/doc/refman/9.7/en/performance-schema-user-defined-functions-table.html

The value is one of int, decimal, real, char, or row. The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. For information about ...

10.2.1.22 Row Constructor Expression Optimization

https://dev.mysql.com/doc/refman/9.7/en/row-constructor-optimization.html

Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. For example, these two statements ...

15.7.7.12 SHOW CREATE TABLE Statement

https://dev.mysql.com/doc/refman/9.7/en/show-create-table.html

row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci SHOW CREATE TABLE displays ... SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named ...

15.7.7.24 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/9.7/en/show-index.html

That is, the number of indexed characters if the column is only partly indexed, NULL if the entire column is indexed. However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as ...

15.1.24.7 Silent Column Specification Changes

https://dev.mysql.com/doc/refman/9.7/en/silent-column-changes.html

If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. Specifying the CHARACTER SET binary ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...

Displaying 121 to 130 of 135 total results