PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-latency.html
total_latency The total wait time of timed statements for the host. max_latency The maximum single wait time of timed statements for the host. lock_latency The total time waiting for locks by timed statements for the host. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-type.html
total_latency The total wait time of timed occurrences of the statement event for the host. max_latency The maximum single wait time of timed occurrences of the statement event for the host. lock_latency The total time waiting for locks by timed ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-latency.html
total_latency The total wait time of timed statements for the user. max_latency The maximum single wait time of timed statements for the user. lock_latency The total time waiting for locks by timed statements for the user. The ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary-by-statement-type.html
total_latency The total wait time of timed occurrences of the statement event for the user. max_latency The maximum single wait time of timed occurrences of the statement event for the user. lock_latency The total time waiting for locks by timed ...
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) ...
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 ...
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 ...
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 ...
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 ...
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 ...