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/adding-collation-simple-8bit.html
Choose a collation ID, as shown in Section 10.14.2, “Choosing a Collation ID”. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; ... This ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
Additional Resources Example showing how to add a collation for full-text searches: Section 12.9.7, “Adding a User-Defined Collation for Full-Text Indexing” The Unicode Collation Algorithm (UCA) specification: ... A collation is a set of rules ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
ANALYZE TABLE Output Key Distribution Analysis Other Considerations ANALYZE TABLE Output ANALYZE TABLE returns a result set with the columns shown in the following table. To check the stored key distribution cardinality, use the SHOW INDEX statement ...ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
Note This section describes legacy audit log filtering, which applies under either of these circumstances: Before MySQL 5.7.13, that is, prior to the introduction of rule-based audit log filtering described in Section 6.4.5.7, “Audit Log ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
Table 12.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-find-table.html
You can check which tables are in the default database with SHOW TABLES. Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase.
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
SHOW SLAVE STATUS reports the status for all channels, except the group_replication_applier channel. When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-charsets.html
To list the available character sets and their default collations, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. There is one subsection for each group of related character sets. To avoid choosing the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
To determine which collations are available for each character set, use the SHOW COLLATION statement or query the INFORMATION_SCHEMA COLLATIONS table. The examples given here show what the setting might look like for Unix or Windows, respectively: ... The MySQL server has a compiled-in default character set and ...