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/cursor-restrictions.html
For example, if a client executes a query but is only interested in the first row, the remaining rows are not transferred. Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
Use UPGRADE DATA DIRECTORY NAME in this case to explicitly tell the server to re-encode the database directory name to the current encoding format: ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; After executing this statement, you can ...ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
Clients that connect to the server using the account then get an error indicating that the password must be changed: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. Operations performed by ...Password expiration according to policy is automatic and is based on password age, which for a given account is assessed from the date and time of its most recent password ...
https://dev.mysql.com/doc/refman/5.7/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
Although an ALTER EVENT statement that contains another ALTER EVENT statement in its DO clause appears to succeed, when the server attempts to execute the resulting scheduled event, the execution fails with an error. When a user executes a ... ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-index-statistics.html
select_latency The total wait time of timed reads using the index. insert_latency The total wait time of timed inserts into the index. update_latency The total wait time of timed updates in the index. delete_latency The total wait time of timed ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...The log consists of a set of binary log files, plus an index file (see Section 5.4.4, “The Binary ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-visual-studio.html
Query statistics view, displaying information about the executed query such as execution times, processed rows, index and temporary tables usage, and more. The following MySQL for Visual Studio features are available as of version 2.0.2: JavaScript ... This section explains how to use MySQL Shell to script a server using MySQL for Visual ...