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/xml-functions.html
Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Do not output explicit error ...Note It is possible to obtain XML-formatted output from MySQL in the mysql and mysqldump clients by invoking them with the --xml ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
This limit has been identified from testing and benchmarking as a safe boundary where the group performs reliably on a stable local area network. And you can likely scale-out a small fraction of your IO operations, since remote servers receive only ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-performance.html
If necessary, you can employ USE INDEX or FORCE INDEX to alter the execution plan. Unique hash indexes created with USING HASH cannot be used for accessing a table if NULL is given as part of the key. The following performance issues are specific ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
For example (using the same event e_daily defined and then altered in Section 13.7.5.18, “SHOW EVENTS Statement”): mysql> SHOW CREATE EVENT myschema.e_daily\G *************************** 1. SHOW CREATE EVENT event_name This statement displays ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
When validate_password_check_user_name is enabled, it has these effects: Checking occurs in all contexts for which validate_password is invoked, which includes use of statements such as ALTER USER or SET PASSWORD to change the current user's ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
The definition of an existing event can be changed by means of the ALTER EVENT statement. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The collation ID that you choose appears in these contexts: The ID column of the Information Schema COLLATIONS table. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-simple-8bit.html
</charset> In the latin1.xml configuration file, add a <collation> element that names the collation and that contains a <map> element that defines a character code-to-weight mapping table for character codes 0 to 255. This section describes how to ...