PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-context-mysql-feature-ports.html
InnoDB Cluster relies on Group Replication so this applies equally to instances used in a cluster. If you enable certain MySQL features, you might need to set the SELinux TCP port context for additional ports used by those features. If ports used ...
https://dev.mysql.com/doc/refman/5.7/en/server-administration.html
MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation.
https://dev.mysql.com/doc/refman/5.7/en/set-character-set.html
SET {CHARACTER SET | CHARSET} {'charset_name' | DEFAULT} This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables: character_set_client and ...
https://dev.mysql.com/doc/refman/5.7/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...