PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-conversion.html
When converting utf8mb3 columns to utf8mb4, you need not worry about converting supplementary characters because there are none. In terms of table structure, these are the primary potential incompatibilities: For the variable-length character data ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...
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/create-tablespace.html
The rounded values are also used by the NDB kernel for calculating Information Schema FILES column values and other purposes. For an NDB table assigned to a tablespace, only those columns which are not indexed are stored on disk, and actually use ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
The number, order, names, and types of columns and indexes of the partitioned table and the nonpartitioned table must match exactly. Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There are no ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
In this case, the difference in the second column name is lost and both statements are considered the same. The statement event tables (events_statements_current, events_statements_history, and events_statements_history_long) have columns for ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
If this is not the case, an error is generated and the function does not run, unless log_bin_trust_function_creators=1 is specified to override this check (see below). SELECT statements when the source column expressions refer to local variables.
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 ...