PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/8.0/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Required credentials for clients that connect to the MySQL server can include a password. MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the ...
https://dev.mysql.com/doc/refman/8.0/en/binlog.html
This statement can execute only format description events and row events. It is generated by the mysqlbinlog program as the printable representation of certain events in binary log files. (See Section 6.6.9, “mysqlbinlog — Utility for Processing ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
row *************************** Variable_name: Caching_sha2_password_rsa_public_key Value: -----BEGIN PUBLIC KEY----- MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDO9nRUDd+KvSZgY7cNBZMNpwX6 MvE1PbJFXO7u18nJ9lwc99Du/E7lw6CVXw7VKrXPeHbVQUzGyUNkf45Nz/ckaaJa ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...
https://dev.mysql.com/doc/refman/8.0/en/call.html
When the procedure returns, a client program can also obtain the number of rows affected for the final statement executed within the routine: At the SQL level, call the ROW_COUNT() function; from the C API, call the mysql_affected_rows() function.
https://dev.mysql.com/doc/refman/8.0/en/change-replication-filter.html
The precise effects of REPLICATE_DO_DB and REPLICATE_IGNORE_DB filters are dependent on whether statement-based or row-based replication is in effect. Filters set using this statement differ from those set using the server options in two key ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different rows in the same column of the results of these operations would be in different character sets. Metadata is “the ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-stop.html
If necessary, you can stop a cloning operation with a KILL QUERY processlist_id statement. On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
This happens because InnoDB stores row locks in a format such that it cannot know afterward which lock was set by which statement. SET autocommit disables or enables the default autocommit mode for the current session. This means that, when not ...