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/charset-repertoire.html
String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode range U+0000 to U+007F. The ASCII range is a subset of UNICODE range, so a string ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
However, quotation marks are necessary to specify a user_name string containing special characters (such as -), or a host_name string containing special characters or wildcard characters such as % (for example, 'test-user'@'%.com'). Quote user names ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server-side-help.html
mysql> help search_string If you provide an argument to the help command, mysql uses it as a search string to access server-side help from the contents of the MySQL Reference Manual. mysql> SHOW BINARY LOGS; +---------------+-----------+ | Log_name ...The proper operation of this command requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, “Server-Side Help ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
For comparisons of strings to indexed generated columns that compute a value from a JSON function that returns a quoted string, JSON_UNQUOTE() is needed in the column definition to remove the extra quotes from the function value. For example, if the ...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 ...
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 each row in the table, MATCH() returns a relevance value; that is, a similarity measure ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
In MIN(), MAX(), and other aggregate functions, MySQL currently compares ENUM and SET columns by their string value rather than by the string's relative position in the set. Even if you use lower_case_table_names=2 (which enables MySQL to remember ... This section lists known issues in recent versions of ...
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/sql-prepared-statements.html
For example, the C API provides a set of function calls that make up its prepared statement API. For example, you cannot use the mysql_stmt_prepare() C API function to prepare a PREPARE, EXECUTE, or DEALLOCATE PREPARE statement. SQL syntax for ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful. For descriptions of functions that operate on temporal values, see Section 12.7, “Date and Time Functions”. 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/query-cache-operation.html
In addition, query strings that are identical may be treated as different for other reasons. Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, “Query Cache Configuration”, describes how to control whether it is ...