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/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/server-options.html
--ignore-db-dir=dir_name Command-Line Format --ignore-db-dir=dir_name Deprecated 5.7.16 Type Directory name This option tells the server to ignore the given directory name for purposes of the SHOW DATABASES statement or INFORMATION_SCHEMA tables.
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. See Section 4.5.1, “mysql ...
https://dev.mysql.com/doc/refman/5.7/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
These mappings make it easier to import table definitions from other database systems into MySQL. To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. If you create ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql database are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...