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/revoke.html
To use this REVOKE syntax, you must have the global CREATE USER privilege, or the UPDATE privilege for the mysql system database. The REVOKE statement enables system administrators to revoke privileges from MySQL accounts. For details on the levels ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html
Users communicate with the plugin by modifying the set of rules stored in this table. MySQL supports query rewrite plugins that can examine and possibly modify SQL statements received by the server before the server executes them. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
Sometimes there are other ways to test membership in a set of values than by using a subquery. Also, on some occasions, it is not only possible to rewrite a query without a subquery, but it can be more efficient to make use of some of these ...
https://dev.mysql.com/doc/refman/5.7/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. For example, these two statements ...
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
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. SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/5.7/en/security-plugins.html
This helps harden MySQL Server against attacks such as SQL injection or attempts to exploit applications by using them outside of their legitimate query workload characteristics. MySQL includes several plugins that implement security features: ...
https://dev.mysql.com/doc/refman/5.7/en/select-benchmarking.html
For example: mysql> SELECT BENCHMARK(1000000,1+1); +------------------------+ | BENCHMARK(1000000,1+1) | +------------------------+ | 0 | +------------------------+ 1 row in set (0.32 sec) This result was obtained on a Pentium II 400MHz system. To ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
For more information about this optimization, see Conditions for NDB pushdown joins. Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a top priority, whether to achieve ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...