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/adding-collation.html
The following sections describe how to add user-defined collations of the first two types to existing character sets. All existing character sets already have a binary collation, so there is no need here to describe how to add one. However, instead ... A collation is a set of rules that defines how to compare and sort character ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
The audit log plugin performs certain actions during initialization and termination based on the effective audit log file name: As of MySQL 5.7.21: During initialization, the plugin checks whether a file with the audit log file name already exists ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
It is not an error for the filter not to exist. If the filter already exists and is used by any current sessions, those sessions are detached from the filter and are no longer logged. Modifications to audit_log_exclude_accounts affect only ...Unless ...
https://dev.mysql.com/doc/refman/5.7/en/change-master-to.html
Providing a FOR CHANNEL channel clause applies the CHANGE MASTER TO statement to a specific replication channel, and is used to add a new channel or modify an existing channel. For example, to add a new channel called channel2: CHANGE MASTER TO ...] ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
Starting with MySQL NDB Cluster 7.5.3, you can set READ_BACKUP for an existing table online (Bug #80858, Bug #23001617), using an ALTER TABLE statement similar to one of those shown here: ALTER TABLE ... To keep comment values from reverting to ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
logfile_group must be an existing log file group created with CREATE LOGFILE GROUP (see Section 13.1.15, “CREATE LOGFILE GROUP Statement”). When creating an InnoDB general tablespace outside of the data directory, the directory must exist prior ...The precise syntax and semantics depend on the storage engine ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... An error occurs if you try to create an account that already exists. If the IF NOT EXISTS clause is given, the statement produces a warning for each named account that ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. Any table or view referred to in the definition must exist. For information about restrictions on view use, ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
In-Place Downgrade Logical Downgrade In-Place Downgrade In-place downgrade involves shutting down the new MySQL version, replacing the new MySQL binaries or packages with the old ones, and restarting the old MySQL version on the existing data ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. IF EXISTS is used to prevent an error from occurring if the database does not exist. The DROP DATABASE statement removes from the ...Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the ...