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/set-variable.html
User-Defined Variable Assignment Parameter and Local Variable Assignment System Variable Assignment SET Error Handling Multiple Variable Assignment System Variable References in Expressions User-Defined Variable Assignment User-defined variables are ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. row ...
https://dev.mysql.com/doc/refman/5.7/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
If no clause is named and no extra channels exist, the statement applies to the default channel. When a replication channel has gaps, the replica’s database is in a state that might never have existed on the source. START SLAVE [thread_types] ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
These variables do not exist outside of stored procedure context, so a statement that refers to such a variable cannot be logged literally. To handle this, MySQL writes a SET statement to the binary log to make sure that the variable exists on the ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
If the file does not exist or cannot be read because one of the preceding conditions is not satisfied, the function returns NULL. mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc')); -> 'JWJj', 'abc' Different base-64 encoding schemes ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
mysql_upgrade returns an error if a sys schema exists but has no version view, on the assumption that absence of this view indicates a user-created sys schema. To upgrade in this case, remove or rename the existing sys schema first. MySQL 5.7 ...