PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-coercibility.html
A “system constant” (the string returned by functions such as USER() or VERSION()) has a coercibility of 3. In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
The metadata requirements mean that the return values of the USER(), CURRENT_USER(), SESSION_USER(), SYSTEM_USER(), DATABASE(), and VERSION() functions have the UTF-8 character set by default. If you are using (for example) the USER() function for ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
Note Within all stored programs (stored procedures and functions, triggers, and events), the parser treats BEGIN [WORK] as the beginning of a BEGIN ... If a SELECT statement within a transaction calls a stored function, and a statement within the ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
MySQL supports the following static probes, organized into groups of functionality. Either use the probes sparingly, or use counter or aggregation functions to report on these probes and then provide a summary when the script terminates or as part ...To identify each argument within the definitions they are provided with a descriptive name, but you must access the information using the corresponding argN ...
https://dev.mysql.com/doc/refman/5.7/en/error-interfaces.html
Regardless of whether an error originates from within the client library or is received from the server, a MySQL client program obtains the error code, SQLSTATE value, message string, and other related information by calling C API functions in the ... Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
How is InnoDB data-at-rest encryption different from encryption functions MySQL already provides? A.17.11. How is InnoDB data-at-rest encryption different from encryption functions MySQL already provides? There are symmetric and asymmetric ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
Note It is not possible to issue FLUSH statements within stored functions or triggers. However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. Note The DES_ENCRYPT() and DES_DECRYPT() ...| ...
https://dev.mysql.com/doc/refman/5.7/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. Applications that require geometically valid geometries should check them using the ST_IsValid() function.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
As long as the remaining members are a majority of the group they can elect a new primary and continue to function as a group. You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
InnoDB API functions are passed to the InnoDB memcached engine as callback functions. InnoDB API functions access the InnoDB tables directly, and are mostly DML operations with the exception of TRUNCATE TABLE. InnoDB API for the InnoDB memcached ...