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/derived-table-optimization.html
The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution plans.
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
If the default database is dropped, the default database is unset (the DATABASE() function returns NULL). DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
For example, you could use the GET_LOCK() function, or row or table locking. MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be ...
https://dev.mysql.com/doc/refman/5.7/en/expired-password-handling.html
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password. Passwords can be expired manually, and on the basis of a policy for automatic expiration (see Section 6.2.11, ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
In the following section, we provide answers to questions that are most frequently asked about MySQL Replication. Must the replica be connected to the source all the time? A.14.2. Must I enable networking on my source and replica to enable ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-security.html
Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Does MySQL include support for Roles Based Access Control (RBAC)? ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
A trigger can also affect other tables, but it is not permitted to modify a table that is already being used (for reading or writing) by the statement that invoked the function or trigger. Where can I find the documentation for MySQL 5.7 triggers? ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-elements.html
Administrative functions provide an API for lower-level tasks such as synchronizing the cache with persistent storage. MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. Many of these constructs contain other statements, as indicated by the grammar specifications in the following sections. For ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
Note By making this change, you severely decrease MySQL's ability to provide adequate relevance values for the MATCH() function. You can exert more control over full-text searching behavior if you have a MySQL source distribution because some ...