MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 241 to 246 of 246 total results

« Previous
23
24
25
Next »

30.4.4.22 The ps_trace_statement_digest() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html

If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and indicate the polling duration and interval. The result is a report of all ...

30.4.4.23 The ps_trace_thread() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html

in_interval DECIMAL(20,2): The number of seconds (which can be fractional) to sleep between data collections. Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each ...

7.1.15 MySQL Server Time Zone Support

https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html

This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second support. Time Zone Variables Populating the ...Beginning with MySQL 8.0.19, time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more ...

27.5.4 The View WITH CHECK OPTION Clause

https://dev.mysql.com/doc/refman/8.0/en/view-check-option.html

The check for v3 also fails: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given for an ...

15.6.5.8 WHILE Statement

https://dev.mysql.com/doc/refman/8.0/en/while.html

Example: CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO ... [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the ...

14.11 XML Functions

https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html

This also means the user is fully responsible for any typographical errors, since no warnings are given if (for example) $@myvairable is used where $@myvariable was intended. code injection occurs when malicious code is introduced into the system to ... Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in ...