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-on-duplicate.html
If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. With ON DUPLICATE KEY UPDATE, the affected-rows value per row is 1 if the row ...If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is ...If ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source server, see Section ... This section describes a process for configuring and starting GTID-based replication in MySQL ...For information about ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm wait/synch/cond/sql/BINLOG::update_cond wait/synch/mutex/mysys/BITMAP_mutex wait/synch/mutex/sql/LOCK_delete ...This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
For additional information about configuring event collection, see Section 29.3, “Performance Schema Startup Configuration”, and Section 29.4, “Performance Schema Runtime Configuration”. During execution of an ALTER TABLE statement, the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-channel-based-filters.html
Channel specific replication filters are particularly useful in a multi-source replication topology when the same database or table is present on multiple sources, and the replica is only required to replicate it from one source. For instructions to ... This section explains how to work with replication filters when multiple replication channels exist, for example in a multi-source replication ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the event. LAST_ALTERED The date and time when the event was last modified. TIME_ZONE The event time zone, which is the time zone used for scheduling the ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...Note MySQL also provides a MeCab full-text parser plugin for Japanese, which tokenizes documents into meaningful ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components, and the keyring_file and keyring_encrypted_file plugins are not intended as a regulatory compliance solution. Security standards such ... Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and ...This ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first two columns, the first three columns, and so on. If this column is short, reasonably unique, and indexed, ... MySQL can create composite indexes (that is, indexes on multiple ...