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/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT statements. Reparsing uses the default database and SQL mode that were in effect for the original conversion to internal form. For certain statements ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. However, this method may not scale well in situations where thousands of concurrent transactions are initiating updates to ...
https://dev.mysql.com/doc/refman/8.0/en/alter-server.html
For example, to update the USER option: ALTER SERVER s OPTIONS (USER 'sally'); ALTER SERVER causes an implicit commit. ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the ...
https://dev.mysql.com/doc/refman/8.0/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Table 8.34 Audit Log Class and Event Combinations Class Value Permitted Event Values audit startup, shutdown connection connect, change_user, disconnect general status table_access_data read, delete, insert, update connection_data Information about ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
You can also create a binary backup simply by copying the table files, as long as the server is not updating anything. Also, even if the server is not actively updating data, InnoDB may still have modified data cached in memory and not flushed to ...
https://dev.mysql.com/doc/refman/8.0/en/channels-startup-options.html
--log-replica-updates or --log-slave-updates All transactions received by the replica (even from multiple sources) are written in the binary log. This section describes startup options which are impacted by the addition of replication channels. The ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
To remove these bytes, use the TRIM() function: UPDATE t SET col1 = TRIM(TRAILING 0x00 FROM col1); Suppose that table t has a nonbinary column named col1 defined as CHAR(50) CHARACTER SET latin1 but you want to convert it to use utf8mb4 so that you ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...