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/rewriting-subqueries.html
MySQL Server supports multiple-table DELETE statements that can be used to efficiently delete rows based on information from one table or even from many tables at the same time. Sometimes there are other ways to test membership in a set of values ...
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
If the current transaction has a savepoint with the same name, the old savepoint is deleted and a new one is set. In this case, the row lock is released in the undo.) Savepoints that were set at a later time than the named savepoint are deleted. All ... SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
A subquery's outer statement can be any one of: SELECT, INSERT, UPDATE, DELETE, SET, or DO. This applies to statements such as DELETE, INSERT, REPLACE, UPDATE, and (because subqueries can be used in the SET clause) LOAD DATA. All subquery forms and ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
In a DELETE trigger, only OLD.col_name can be used; there is no new row. 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, ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html
Incompatible change: MySQL 5.6.22 and later recognized the REFERENCES privilege but did not entirely enforce it; a user with at least one of SELECT, INSERT, UPDATE, DELETE, or REFERENCES could create a foreign key constraint on a table. Before ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
The following example establishes the server token list, modifies it by adding a new token, deletes some tokens, and displays the resulting token list: mysql> SELECT version_tokens_set('tok1=a;tok2=b'); +-------------------------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
Warning You must exercise great care when editing your system PATH by hand; accidental deletion or modification of any portion of the existing PATH value can leave you with a malfunctioning or even unusable system. Then use SC DELETE ... On Windows, ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
Qcache_lowmem_prunes: Number of queries which were deleted from query cache due to lack of free memory in cache. Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
For a faster count, create a counter table and let your application update it according to the inserts and deletes it does. This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, ...