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/row-subqueries.html
For information about how each operator works for row comparisons, see Section 12.4.2, “Comparison Functions and Operators”. Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined variable, stored procedure or function parameter, or stored program local variable. INTO form of SELECT enables a query result to be ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-context-mysql-feature-ports.html
If ports used by MySQL features do not have the correct SELinux context, the features might not function correctly. If you enable certain MySQL features, you might need to set the SELinux TCP port context for additional ports used by those features. The following sections describe how to set port contexts for MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/semijoins.html
It must not be implicitly grouped (it must contain no aggregate functions). A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
This is the same value displayed in the ID column of the INFORMATION_SCHEMA PROCESSLIST table, displayed in the PROCESSLIST_ID column of the Performance Schema threads table, and returned by the CONNECTION_ID() function within the thread. SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/source-installation.html
Warning Building MySQL with nonstandard options may lead to reduced functionality, performance, or security. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation location. For a ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
END compound statement and other statements that can be used in the body of stored programs: Stored procedures and functions, triggers, and events. These objects are defined in terms of SQL code that is stored on the server for later invocation (see ...
https://dev.mysql.com/doc/refman/5.7/en/subqueries.html
A subquery can contain many of the keywords or clauses that an ordinary SELECT can contain: DISTINCT, GROUP BY, ORDER BY, LIMIT, joins, index hints, UNION constructs, comments, functions, and so on. All subquery forms and operations that the SQL ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply ...