MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 351 to 360 of 593 total results

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

22.1 Overview of Partitioning in MySQL

https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html

This section provides a conceptual overview of partitioning in MySQL 5.7. For information on partitioning restrictions and feature limitations, see Section 22.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...

25.12.6.4 The prepared_statements_instances Table

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html

OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME For a prepared statement created by a client session, these columns are NULL. These columns can be used to find stored programs that leak prepared statements: SELECT OWNER_OBJECT_TYPE, ...

8.2.1.19 Row Constructor Expression Optimization

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

row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: const rows: 3 filtered: 100.00 Extra: Using where In such cases, rewriting the row constructor ...For ...

13.2.9 SELECT Statement

https://dev.mysql.com/doc/refman/5.7/en/select.html

This exception may not apply to const or system tables that are used on the NULL-complemented side of an outer join (that is, the right-side table of a LEFT JOIN or the left-side table of a RIGHT JOIN. SELECT [ALL | DISTINCT | DISTINCTROW ] ...

11.3.6 The SET Type

https://dev.mysql.com/doc/refman/5.7/en/set.html

For example, a column specified as SET('one', 'two') NOT NULL can have any of these values: '' 'one' 'two' 'one,two' A SET column can have a maximum of 64 distinct members. A SET is a string object that can have zero or more values, each of which ...

13.7.5.10 SHOW CREATE TABLE Statement

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

row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 SHOW CREATE TABLE quotes table and column names ...

11.4.1 Spatial Data Types

https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html

MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...

26.4.5.10 The ps_is_consumer_enabled() Function

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html

Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. (Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the ...If the argument is not a valid consumer name, an error ...

6.2.18 SQL-Based Account Activity Auditing

https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html

Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host ...

Displaying 351 to 360 of 593 total results