https://dev.mysql.com/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/security-guidelines.html
This information is accessible to everyone who has the time and ability to intercept it and use it for their own purposes. Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security ...
https://dev.mysql.com/select.html
This helps MySQL free the table locks early and helps in cases where it takes a long time to send the result set to the client. SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] ...
https://dev.mysql.com/server-configuration-defaults.html
For general instructions on setting parameters at startup or runtime, see Section 5.1.7, “Server Command Options”, and Section 5.1.8, “Server System Variables”. After completing the installation process, you can edit the default option file ... The MySQL server has many operating parameters, which you can change at server startup using command-line options or configuration files (option ...
https://dev.mysql.com/server-configuration-validation.html
--validate-config can be used any time, but is particularly useful after an upgrade, to check whether any options previously used with the older server are considered by the upgraded server to be deprecated or obsolete. As of MySQL 8.0.16, MySQL ...
https://dev.mysql.com/server-configuration.html
To use the option every time the server runs, put it in an option file. The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To determine the default command option and ...
https://dev.mysql.com/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/session-account-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see Section 26.12.9, “Performance Schema Connection Attribute Tables”. The ...
https://dev.mysql.com/session-connect-attrs-table.html
Application programs can provide key-value connection attributes to be passed to the server at connect time. For descriptions of common attributes, see Section 26.12.9, “Performance Schema Connection Attribute Tables”. To see connection ...
https://dev.mysql.com/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. One use for the tracker mechanism is to provide a means for MySQL connectors and client applications to determine whether any session context is available to ...
