PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
This prevents most The table tbl_name is full errors for SELECT operations that require a large temporary table, but also slows down queries for which in-memory tables would suffice. This variable is used to interpret string literals that refer to ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
If a path selects a scalar or object value, that value is autowrapped within an array and the new value is added to that array. mysql> SELECT JSON_MERGE('[1, 2]', '[true, false]'); +---------------------------------------+ | JSON_MERGE('[1, 2]', ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
mysql> SELECT 'fo\nfo' REGEXP '^fo$'; -> 0 mysql> SELECT 'fofo' REGEXP '^fo'; -> 1 $ Match the end of a string. mysql> SELECT 'fo\no' REGEXP '^fo\no$'; -> 1 mysql> SELECT 'fo\no' REGEXP '^fo$'; -> 0 . mysql> SELECT 'fofo' REGEXP '^f.*$'; -> 1 mysql> ... Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular expression RLIKE Whether string matches regular expression A regular expression is a powerful way of specifying a pattern for a complex ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
The select_statement is a SELECT statement that provides the definition of the view. (Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. For example, if a ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
Strings produced by converting JSON values have a character set of utf8mb4 and a collation of utf8mb4_bin: mysql> SELECT CHARSET(@j), COLLATION(@j); +-------------+---------------+ | CHARSET(@j) | COLLATION(@j) | +-------------+---------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Getting general information about fragments and memory usage This query shows general information about memory usage for each fragment: mysql> SELECT -> fq_name, node_id, block_instance, fragment_num, fixed_elem_alloc_bytes, -> ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
(This technique is inapplicable if NULL must be permitted as a valid name value.) Use ANY_VALUE() to refer to address: SELECT name, ANY_VALUE(address), MAX(age) FROM t GROUP BY name; In this case, MySQL ignores the nondeterminism of address values ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
For example, to refer to a table named FOO#BAR or a column named SELECT, you would specify the identifiers as `FOO#BAR` and `SELECT`. A query such as SELECT c1 FROM t1 WHERE c1 = 50; thus might return 1 row or a huge number of rows, and the database ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by ...
https://dev.mysql.com/doc/refman/5.7/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... The effect of this option is that ...index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ...