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/implicit-commit.html
CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is used. (This does not apply to other operations on temporary tables such as ALTER TABLE and CREATE INDEX, which do cause a commit.) However, although no ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
For NDB: The name of an undo log file created by CREATE LOGFILE GROUP or ALTER LOGFILE GROUP, or of a data file created by CREATE TABLESPACE or ALTER TABLESPACE. This means, for example, that the name of a data file created with ALTER TABLESPACE ts ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-hashicorp-plugin.html
The following instructions describe how to create the certificate and key files using OpenSSL. (Optional) To check key file content and validity, use the following commands: openssl rsa -in company.key -check openssl rsa -in vault.key -check Create ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
To refer to the PAM authentication plugin in the IDENTIFIED WITH clause of a CREATE USER statement, use the name authentication_pam. For example: CREATE USER user IDENTIFIED WITH authentication_pam AS 'auth_string'; The authentication string ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. By default, triggers that have the same ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
The server creates binary log files in sequence by adding a numeric suffix to the base name. The binary log is a sequence of files with a base name and numeric extension. The --log-bin option value is the base name for the log sequence. For example, ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
To force them to be created (or updated if they already exist), invoke ndb_index_stat with the --update option, or execute ANALYZE TABLE on the table in the mysql client. --sys-create Command-Line Format --sys-create Create all statistics tables and ... ndb_index_stat provides per-fragment statistical information about indexes on NDB ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...