PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-applications.html
To create a database such that its tables use a given default character set and collation for data storage, use a CREATE DATABASE statement like this: CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_general_ci; Tables created in the database ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
Create the secret by passing the key length to create_dh_parameters(), then pass the secret as the “key length” to create_asymmetric_priv_key(). Limit CPU usage by key-generation operations The create_asymmetric_priv_key() and ... To use MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysql_install_db This program initializes the MySQL data directory, creates the mysql database and initializes its grant tables with default privileges, and sets up the InnoDB system tablespace. mysql_ssl_rsa_setup This program creates the SSL ...
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
This makes ANALYZE TABLE fast on InnoDB tables but not 100% accurate because it does not take all rows into account. ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or tables. For MyISAM tables, ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-conversion.html
Conversion of DATETIME and TIMESTAMP values: Conversion to a DATE value takes fractional seconds into account and rounds the time part. To some extent, you can convert a value from one temporal type to another. However, there may be some alteration ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
mysql> SET GLOBAL group_replication_recovery_retry_count= 10; Note that this accounts for the global number of attempts that the server joining the group makes connecting to each one of the suitable donors. Whenever a new member joins a replication ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-table-reference.html
Table 24.9 INFORMATION_SCHEMA Connection Control Tables Table Name Description CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account .
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
The functions in this section modify JSON values and return the result. JSON_APPEND(json_doc, path, val[, path, val] ...) Appends values to the end of the indicated arrays within a JSON document and returns the result. This function was renamed to ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-encrypted-file-plugin.html
Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. The keyring_encrypted_file keyring plugin stores keyring data in an encrypted, password-protected file local to the server host.