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/case.html
CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE Or: CASE WHEN search_condition THEN statement_list [WHEN search_condition THEN statement_list] ... [ELSE statement_list] ...
https://dev.mysql.com/doc/refman/5.7/en/channels-commands-single-channel.html
To enable MySQL replication operations to act on individual replication channels, use the FOR CHANNEL channel clause with the following replication statements: CHANGE MASTER TO START SLAVE STOP SLAVE SHOW RELAYLOG EVENTS FLUSH RELAY LOGS SHOW SLAVE ...
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
See Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) Specify character settings at server startup. For applications that store data using the default MySQL character set and collation (latin1, latin1_swedish_ci), no special ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
Complex collations for 8-bit character sets This kind of collation is implemented using functions in a C source file that define how to order characters, as described in Section 10.13, “Adding a Character Set”. mysql> SET NAMES 'utf8' COLLATE ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
For stored routines (procedures and functions), the database character set and collation in effect at routine creation time are used as the character set and collation of character data parameters for which the declaration includes no CHARACTER SET ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE functionality for InnoDB SPATIAL indexes includes an R-tree validity check and a check to ensure that the R-tree row count matches the clustered index. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/checksum-table.html
However, because the hashing function used by CHECKSUM TABLE is not guaranteed to be collision-free, there is a slight chance that two tables which are not identical can produce the same checksum. [QUICK | EXTENDED] CHECKSUM TABLE reports a checksum ...
https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
The mysql_options() C API function supports a MYSQL_ENABLE_CLEARTEXT_PLUGIN option that enables the plugin on a per-connection basis. A client-side authentication plugin is available that enables clients to send passwords to the server as ...
https://dev.mysql.com/doc/refman/5.7/en/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you ...