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/mysql-cluster-what-is-new-7-6.html
NDB 7.6 adds two tables to the ndbinfo information database to provide information about cluster nodes; these tables are listed here: config_nodes: This table the node ID, process type, and host name for each node listed in an NDB cluster's ... New ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
You can precede the SELECT by IGNORE or REPLACE to indicate how to handle rows that duplicate unique key values. With REPLACE, new rows replace rows that have the same unique key value. If neither IGNORE nor REPLACE is specified, duplicate unique ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Items then can be selected from registered dictionaries and used as random values or as replacements for other values. Its arguments are the term to replace, the dictionary in which the term appears, and the dictionary from which to choose a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html
This includes single-row and multiple-row INSERT and REPLACE statements that do not have a nested subquery, but not INSERT ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL ...
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(). If the second object has a member with a key matching a member in the first object, JSON_MERGE_PATCH() replaces the value in the first object with ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-simplification.html
This results in a query with no outer joins at all: SELECT * FROM (T1 INNER JOIN T2 ON T2.A=T1.A), T3 WHERE T3.C > 0 AND T3.B=T2.B Sometimes the optimizer succeeds in replacing an embedded outer join operation, but cannot convert the embedding outer ... Table expressions in the FROM clause of a query are simplified in many ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
SQL statements supporting explicit partition selection are listed here: SELECT DELETE INSERT REPLACE UPDATE LOAD DATA. MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. The effect of the replication filtering options differs between binary logging formats because of the way the database name is ...It is also important ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
If the database on the source contains existing data it is necessary to copy this data to each replica. To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the ...