PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
For example, '41' is stored into a CHAR(3) column as '41 ' and retrieved as '41' (with the trailing pad space stripped), so UNHEX() for the column value returns X'41'. By contrast, '41' is stored into a BINARY(3) column as '41\0' and retrieved as ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always replicated. The following ...Note ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-lifecycle.html
In the following special cases, a single statement can generate multiple transactions, and therefore be assigned multiple GTIDs: A stored procedure is invoked that commits multiple transactions. After the binary log data is transmitted to the ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.4, “Event Metadata”, shows how to obtain information about events and how this information is stored by the MySQL Server. Stored routines require the events data dictionary table in the mysql system database. If you are upgrading to ... The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
The following stored procedure accepts a UCS-2 Unicode character, converts it to other character sets, and displays the results in hexadecimal. It is also possible to store CJK characters in Unicode character sets, although the available collations ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin.html
The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. A loadable function named load_rewrite_rules() is used by the flush_rewrite_rules() stored procedure.
https://dev.mysql.com/doc/refman/8.0/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Note Within all stored programs, the parser treats BEGIN [WORK] as the beginning of a BEGIN ... A ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
If you use a binary column to store information in multiple character sets, MySQL has no way to know which values use which character set and cannot convert the data properly. To remove these bytes, use the TRIM() function: UPDATE t SET col1 = ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
The group_replication_recovery channel could then be inadvertently started with the stored credentials, on either the original member or members that were cloned from it. An automatic start of Group Replication on server boot (including after a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
The debug information is stored in the GCS_DEBUG_TRACE file in the data directory. For details of the situation in which you might need to force a new group membership, and a procedure to follow when using this system variable, see Section 20.7.8, ... This section lists the system variables that are specific to the Group Replication ...