PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/insert.html
You can use REPLACE instead of INSERT to overwrite old rows. REPLACE is the counterpart to INSERT IGNORE in the treatment of new rows that contain unique key values that duplicate old rows: The new rows replace the old rows rather than being ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
For example, {UA} is replaced with a user name such as "admin", whereas {UD} is replaced with a use full DN such as "uid=admin,ou=People,dc=example,dc=com". For example, {UA} is replaced with a user name such as "admin", whereas {UD} is replaced ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
You can either replace the value of gtid_purged with a specified GTID set, or you can append a specified GTID set to the GTID set that is already held by gtid_purged. To replace the value of gtid_purged with your specified GTID set, use the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html
For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version ...
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
Table 14.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. The portion of xml_target that ...Note It is possible to obtain XML-formatted output from MySQL in the mysql and mysqldump clients by invoking them with the --xml ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-optimization.html
For an explanation of the inner workings of the InnoDB buffer pool, an overview of its LRU replacement algorithm, and general configuration information, see Section 17.5.1, “Buffer Pool”. InnoDB maintains a storage area called the buffer pool ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
Evaluation of some views, such those that use the TEMPTABLE algorithm, UNION, or aggregation. The union is not the top-level query block of an {INSERT | REPLACE} ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-options-variables.html
This variable replaces ndb_slave_conflict_role, which is deprecated as of NDB 8.0.23. Frequent changes in ndb_data_node_neighbour are not advisable, since this changes the state of the cluster connection and thus may disrupt the selection algorithm ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
This works for these algorithms since they both map a WRITE_ROW event to an insert or update depending on whether the row already exists, and the required metadata (the “after” image for the timestamp column) is present in the “WRITE_ROW” ...