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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-foreign-key.html
MySQL supports ON UPDATE and ON DELETE foreign key references in CREATE TABLE and ALTER TABLE statements. MATCH FULL, MATCH PARTIAL, and MATCH SIMPLE are allowed, but their use should be avoided, as they cause the MySQL Server to ignore any ON ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
This may be suitable for short-lived data which is frequently updated, and where the loss of all data in the unlikely event of a total cluster failure is acceptable. NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...