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/switchable-optimizations.html
The subquery_materialization_cost_based flag enables control over the choice between subquery materialization and IN-to-EXISTS subquery transformation. If the flag is on (the default), the optimizer performs a cost-based choice between subquery ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
Trigger names exist in the schema namespace, meaning that all triggers must have unique names within a schema. To affect trigger order, specify a clause after FOR EACH ROW that indicates FOLLOWS or PRECEDES and the name of an existing trigger that ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html
This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or as a Windows service. The information here applies primarily if you ...
https://dev.mysql.com/doc/refman/5.7/en/windows-symbolic-links.html
However, before creating the symbolic link, make sure that the D:\data\mydb directory exists by creating it if necessary. If the database does not already exist, issue CREATE DATABASE mydb in the mysql client to create it. The symbolic link is not ... On Windows, symbolic links can be used for database ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
Use the existing contents in the file as a guide to adding new contents. Look at one of the existing ctype-*.c files (such as ctype-big5.c) to see what needs to be defined. Use the existing configuration information as a guide to adding information ... This section discusses the procedure for adding a character set to ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
It is important to realize when using this syntax that: MySQL does not perform any sort of check to make sure that col_name actually exists in tbl_name (or even that tbl_name itself exists). For example, if you define a RESTRICT type constraint, and ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
find_in_exclude_list(account) Checks whether an account string exists in the audit log exclude list (the value of the audit_log_exclude_accounts system variable). find_in_include_list(account) Checks whether an account string exists in the audit log ...For information about using JSON data in MySQL, see Section 11.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
As of MySQL 5.7.20, filter rules have the capability of blocking (aborting) execution of qualifying events, in addition to existing capabilities for event logging. In addition, the audit tables must exist or an error occurs. Otherwise, if no ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD ...