PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
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/scalar-subqueries.html
A scalar subquery can be part of an expression, but remember the parentheses, even if the subquery is an operand that provides an argument for a function. In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar ...
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/storage-requirements.html
The LENGTH() function returns the space in bytes required for value storage. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements ...