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/sys-ps-is-consumer-enabled.html
Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. (Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the ...If the argument is not a valid consumer name, an error ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
To extract the user name or host name part from a CURRENT_USER() or USER() value, use the SUBSTRING_INDEX() function: mysql> SELECT SUBSTRING_INDEX(CURRENT_USER(),'@',1); +---------------------------------------+ | ... Applications can use the ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server variables, status variables, and options that were added for the first time, have been ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement is used either to add a new data file, or to drop a data file from a tablespace. The ADD DATAFILE variant ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...
https://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. For more complete information, see Section 10.10, “Supported Character Sets and Collations”. mysql> SHOW CHARACTER SET; ...
https://dev.mysql.com/doc/refman/5.7/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump. For additional information if you are unable to connect, see Section 6.2.17, “Troubleshooting ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-like.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; The copy is created using the same version of the table storage ...
https://dev.mysql.com/doc/refman/5.7/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. This section describes how to assign a password to the initial root account created during ...