MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1111 to 1120 of 1164 total results

15.2.15.1 The Subquery as Scalar Operand

https://dev.mysql.com/doc/refman/8.0/en/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 ...

10.13.1 Measuring the Speed of Expressions and Functions

https://dev.mysql.com/doc/refman/8.0/en/select-benchmarking.html

The return value is always zero, but mysql prints a line displaying approximately how long the statement took to execute. For example: mysql> SELECT BENCHMARK(1000000,1+1); +------------------------+ | BENCHMARK(1000000,1+1) | ... To measure the ...

7.1.19 The Server Shutdown Process

https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html

If a thread is updating a nontransactional table, an operation such as a multiple-row UPDATE or INSERT may leave the table partially updated because the operation can terminate before completion. The server shutdown process takes place as follows: ...

15.7.1.10 SET PASSWORD Statement

https://dev.mysql.com/doc/refman/8.0/en/set-password.html

SET PASSWORD interprets the string as a cleartext string, passes it to the authentication plugin associated with the account, and stores the result returned by the plugin in the account row in the mysql.user system table. SET PASSWORD [FOR user] ...

15.3.7 SET TRANSACTION Statement

https://dev.mysql.com/doc/refman/8.0/en/set-transaction.html

transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...

8.4.1.3 SHA-256 Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

row *************************** Variable_name: Rsa_public_key Value: -----BEGIN PUBLIC KEY----- MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDO9nRUDd+KvSZgY7cNBZMNpwX6 MvE1PbJFXO7u18nJ9lwc99Du/E7lw6CVXw7VKrXPeHbVQUzGyUNkf45Nz/ckaaJa ... MySQL provides two ...

15.7.7.3 SHOW CHARACTER SET Statement

https://dev.mysql.com/doc/refman/8.0/en/show-character-set.html

The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all ...

15.7.7.4 SHOW COLLATION Statement

https://dev.mysql.com/doc/refman/8.0/en/show-collation.html

The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By ...

15.7.7.5 SHOW COLUMNS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-columns.html

The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | ...

15.7.7.7 SHOW CREATE EVENT Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html

SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...

Displaying 1111 to 1120 of 1164 total results