MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1791 to 1800 of 2047 total results

30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-waits-by-host-by-latency.html

total_latency The total wait time of timed occurrences of the event for the host. avg_latency The average wait time per timed occurrence of the event for the host. max_latency The maximum single wait time of timed occurrences of the event for the ...

30.4.3.51 The waits_by_user_by_latency and x$waits_by_user_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-waits-by-user-by-latency.html

total_latency The total wait time of timed occurrences of the event for the user. avg_latency The average wait time per timed occurrence of the event for the user. max_latency The maximum single wait time of timed occurrences of the event for the ...

30.4.3.52 The waits_global_by_latency and x$waits_global_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-waits-global-by-latency.html

total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event. max_latency The maximum single wait time of timed occurrences of the event. The waits_global_by_latency and ...

15.2.15.4 Subqueries with ALL

https://dev.mysql.com/doc/refman/8.0/en/all-subqueries.html

Thus, these two statements are the same: SELECT s1 FROM t1 WHERE s1 <> ALL (SELECT s1 FROM t2); SELECT s1 FROM t1 WHERE s1 NOT IN (SELECT s1 FROM t2); MySQL 8.0.19 supports the TABLE statement. The expression is TRUE if table t2 contains (-5,0,+5) ...

15.1.6 ALTER LOGFILE GROUP Statement

https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html

ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...

15.1.7 ALTER PROCEDURE Statement

https://dev.mysql.com/doc/refman/8.0/en/alter-procedure.html

ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...

15.1.8 ALTER SERVER Statement

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

ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...

15.2.15.3 Subqueries with ANY, IN, or SOME

https://dev.mysql.com/doc/refman/8.0/en/any-in-some-subqueries.html

Beginning with MySQL 8.0.19, you can use TABLE in a scalar IN, ANY, or SOME subquery provided the table contains only a single column. The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The ...

15.6.1 BEGIN ... END Compound Statement

https://dev.mysql.com/doc/refman/8.0/en/begin-end.html

In the mysql command-line client, this is handled with the delimiter command. END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). A compound statement ...

11.1.6 Boolean Literals

https://dev.mysql.com/doc/refman/8.0/en/boolean-literals.html

mysql> SELECT TRUE, true, FALSE, false; -> 1, 1, 0, 0 . The constants TRUE and FALSE evaluate to 1 and 0, respectively.

Displaying 1791 to 1800 of 2047 total results