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/partitioning-subpartitions.html
Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) SUBPARTITION BY HASH( TO_DAYS(purchased) ) SUBPARTITIONS 2 ( PARTITION p0 VALUES LESS THAN (1990), PARTITION p1 VALUES LESS ... Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 38.8, CAST(38.8 AS CHAR); -> 38.8, '38.8' mysql> SELECT 38.8, CONCAT(38.8); -> 38.8, '38.8' See later in this section for information about the character set of implicit number-to-string conversions, and for modified rules that apply ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, called the view ... Some ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. For a simple character set, create a configuration file, MYSET.xml, that describes the character set properties. For a complex character set, create a C source file that ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
For example, utf8_unicode_ci works fine for German dictionary order and French, so there is no need to create special utf8 collations. In Japan, since the supplementary characters are obscure Kanji ideographs, the typical user does not care what ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-background.html
The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should continue to operate as expected. This creates a set of challenges that raise ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-temp-table-info-table.html
The INNODB_TEMP_TABLE_INFO table provides information about user-created InnoDB temporary tables that are active in an InnoDB instance. The INNODB_TEMP_TABLE_INFO table is created when first queried, exists only in memory, and is not persisted to ...It does not provide information about internal InnoDB temporary tables used by the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
In general, a newer version of InnoDB may create a table or index that cannot safely be read or written with an older version of InnoDB without risk of crashes, hangs, wrong results or corruptions. This mechanism lets you take advantage of some new ... InnoDB incorporates several checks to guard against the possible crashes and data corruptions that might occur if you run an old release of the MySQL server on InnoDB data files that use a newer file ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
This channel is always present; it cannot be created or destroyed by the user. The maximum number of channels that can be created on one replica in a multi-source replication topology is 256. To provide compatibility with previous versions, the ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
Note The initial root account in the MySQL grant tables has no password. After starting the server, you should set up a password for it using the instructions in Section 2.9.4, “Securing the Initial MySQL Account”. This section gives a general ...