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/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...
https://dev.mysql.com/doc/refman/5.7/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”.
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/server-configuration.html
When tuning a MySQL server, the two most important variables to configure are key_buffer_size and table_open_cache. The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variable-reference.html
The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html
The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables (System Var), and status variables (Status var) in ...If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding ...
https://dev.mysql.com/doc/refman/5.7/en/set-global-sql-slave-skip-counter.html
For nontransactional tables, an event group corresponds to a single SQL statement. Note A single transaction can contain changes to both transactional and nontransactional tables. SET GLOBAL sql_slave_skip_counter = N This statement skips the next ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. Note It is possible to compile MySQL using yaSSL as an alternative to OpenSSL only prior to MySQL 5.7.28. MySQL provides two authentication plugins that implement SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
This statement requires the TRIGGER privilege for the table associated with the trigger. row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
Caution Because a global privilege is considered a privilege for all databases, any global privilege enables a user to see all database names with SHOW DATABASES or by examining the INFORMATION_SCHEMA SCHEMATA table. SHOW {DATABASES | SCHEMAS} ...