MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 291 to 296 of 296 total results

« Previous
28
29
30
Next »

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-save.html

This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...

30.4.4.22 The ps_trace_statement_digest() Procedure

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

Traces all Performance Schema instrumentation for a specific statement digest. 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 ...

30.4.4.23 The ps_trace_thread() Procedure

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

Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...

27.6.4 The View WITH CHECK OPTION Clause

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

The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...

15.6.5.8 WHILE Statement

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

[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 search_condition expression is true. statement_list consists of one or more SQL statements, each ...

14.11 XML Functions

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

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 MySQL. Note It is possible to obtain ...