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/time-zone-support.html
For information about time zone settings in replication setups, see Section 16.4.1.15, “Replication and System Functions” and Section 16.4.1.31, “Replication and Time Zones”. Note If set to SYSTEM, every MySQL function call that requires a ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
Normally, the CURRENT_USER() function can be invoked to determine which account this is for the client user. To determine the invoking user, you can call the USER() function, which returns a value indicating the actual user name provided by the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
The repertoire for function return values is determined based on the repertoire of only those arguments that affect the result's character set and collation. The repertoire of a character set is the collection of characters in the set. String ...
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
Aggregate functions in correlated subqueries may contain outer references, provided the function contains nothing but outer references, and provided the function is not contained in another function or expression. A correlated subquery is a ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
For descriptions of functions that operate on temporal values, see Section 12.7, “Date and Time Functions”. To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful. However, with dates such as these, ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
This can occur if the outer query accesses any tables and an inner query invokes a stored function that changes one or more rows of a table. A derived table is an expression that generates a table within the scope of a query FROM clause. For ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption.html
MySQL Enterprise Edition includes a set of encryption functions based on the OpenSSL library that expose OpenSSL capabilities at the SQL level. MySQL Enterprise Encryption is supplied as a library of loadable functions, from which individual ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
These may invoke administrative functions, so stored procedure access also requires the privileges needed for those functions. Grant the SUPER privilege so that the firewall administrative functions can be executed. Warning Setting the ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. For natural-language full-text searches, the columns named in the MATCH() function must be the ...A collection is a set of one or more columns included in a FULLTEXT ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
The generated column must be defined as an expression that contains at least a function call or one of the operators mentioned in the preceding item. For comparisons of strings to indexed generated columns that compute a value from a JSON function ...For example: CREATE TABLE t1 (f1 INT, gc INT AS (f1 + 1) STORED, INDEX (gc)); The generated column, gc, is defined as the expression f1 + ...