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/replication-features-differing-tables.html
When using statement-based replication, a simple rule of thumb to follow is, “If the statement run on the source would also execute successfully on the replica, it should also replicate successfully”. Between any of the string types CHAR, ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
If pval is 1, p() signals an error and sets the MESSAGE_TEXT condition information item. The error terminates the procedure, and the text is returned with the error information. If pval is anything else, p() first signals a warning and sets the ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than 65535 is converted to TEXT, and a VARBINARY column with a length specification greater than 65535 is converted to BLOB. Specifying the CHARACTER SET binary ... In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; For information about these forms of string syntax, see Section 10.3.7, “The National Character Set”, and Section 10.3.8, “Character Set ... A ...
https://dev.mysql.com/doc/refman/5.7/en/sys-list-add.html
Example mysql> SELECT @@sql_mode; +----------------------------------------+ | @@sql_mode | +----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES | +----------------------------------------+ mysql> SET @@sql_mode = ...
https://dev.mysql.com/doc/refman/5.7/en/sys-list-drop.html
For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified. Removes a value from a comma-separated list of values and returns the result.
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
By default, the strategy value is ASYNCHRONOUS and the plugin logs asynchronously to a buffer, waiting if the buffer is full. A disadvantage of PERFORMANCE strategy is that it drops events when the buffer is full. This section describes how to ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, and binaries in platform-specific package formats for selected platforms. This section covers the installation ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
A good bug report, containing a full test case for the bug, makes it very likely that we will fix the bug in the next release. Please read this section carefully and make sure that all the information described here is included in your report. The ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
For clients that use the caching_sha2_password plugin, passwords are never exposed as cleartext when connecting to the MySQL 8.0 or higher server. The password is sent as cleartext but cannot be snooped because the connection is secure. If a secure ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...