PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
The PARTITIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
The maximum number of attributes (that is, columns and indexes) that can belong to a given table is 512. Each BLOB or TEXT column contributes 256 + 8 = 264 bytes to this total; this includes JSON columns. In addition, the maximum offset for a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. If the table has an index for the columns in question, MySQL can quickly determine the position to seek to in the middle of the data file without having to look at all the data. If ...Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html
The plugin communicates information to users by setting the table's message column. replacement The template that indicates how to rewrite statements matching the pattern column value. Load operations (performed by invoking the flush_rewrite_rules() ...Users communicate with the plugin by modifying the set of rules stored in this ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. If you have fixed-length columns that you access or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
INNODB_SYS_COLUMNS provides metadata about InnoDB table columns, equivalent to the information in the SYS_COLUMNS table in the InnoDB data dictionary. INNODB_SYS_FIELDS provides metadata about the key columns (fields) of InnoDB indexes, equivalent ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. This expression can be a column value, a function acting on one or more column values, or ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is done correctly, subject to the following exceptions: When using statement-based replication prior to MySQL 5.7.1, AUTO_INCREMENT columns in tables on the ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
For strings, MySQL stores either the empty string or as much of the string as can be stored in the column. If you try to store a string that does not start with a number into a numeric column, MySQL Server stores 0. Invalid values for ENUM and SET ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Explicit Default Handling Implicit Default Handling Explicit Default Handling A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. In the definition of an integer column, it is an alias for NOT NULL ... Data type specifications can have explicit or implicit default ...