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/mysql-cluster-replication-issues.html
(A gap event is a type of “incident event,” which indicates an incident that occurs that affects the contents of the database but that cannot easily be represented as a set of changes. For information about implementing this type of setup, see ...If this occurs, it is entirely possible for new data to be inserted into the source cluster without being recorded in the source SQL node's binary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-hosts-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. To set the table size explicitly, set the performance_schema_hosts_size system variable at server startup. The hosts table contains a row for each host from ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
For comparisons between nonbinary string columns, both columns should use the same character set. If the table has an index for the columns in question, MySQL can quickly determine the position to seek to in the middle of the data file without ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
When the optimizer evaluates plans for outer join operations, it takes into consideration only plans where, for each such operation, the outer tables are accessed before the inner tables. (That is, it converts the outer join to an inner join.) A ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
(Unless the NO_BACKSLASH_ESCAPES SQL mode is enabled, in which case no escape character is used.) Regular expression operations use the character set and collation of the string expression and pattern arguments when deciding the type of a character ... 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/apache.html
There are programs that let you authenticate your users from a MySQL database and also let you write your log files into a MySQL table.
https://dev.mysql.com/doc/refman/5.7/en/insert.html
SET forms of the statement insert rows based on explicitly specified values. For example, if you specify a column list that does not name all the columns in the table, unnamed columns are set to their default values. If both the column list and the ...[ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] SET assignment_list [ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
For a comparison of JSON_INSERT(), JSON_REPLACE(), and JSON_SET(), see the discussion of JSON_SET(). \ Please use JSON_MERGE_PRESERVE/JSON_MERGE_PATCH instead 1 row in set (0.00 sec) For additional examples, see the entry for JSON_MERGE_PRESERVE().
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition.html
Normally it is not necessary to define TCP/IP connections; NDB Cluster automatically sets up such connections for all data nodes, management nodes, and SQL or API nodes. It is also possible to change the default values for these parameters by ...To ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. Regardless of the statement ...You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new ...