MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 481 to 490 of 497 total results

5.5.4.3 Rewriter Query Rewrite Plugin Reference

https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html

Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates information to users by setting the table's message column. Note The rules table is loaded into the plugin by the flush_rewrite_rules ...

6.1.7 Client Programming Security Guidelines

https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html

The information returned in a MySQL error is not gratuitous because that information is key in debugging MySQL using applications. Client applications that access MySQL should use the following guidelines to avoid interpreting external data ...

6.1.4 Security-Related mysqld Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/security-options.html

The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 5.1.6, “Server Command Options”, and Section 5.1.7, “Server System Variables”.

5.1.3 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

13.7.5.35 SHOW STATUS Statement

https://dev.mysql.com/doc/refman/5.7/en/show-status.html

SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. For details, see the ...

13.1.18.6 Silent Column Specification Changes

https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html

Columns that are part of a PRIMARY KEY are made NOT NULL even if not declared that way. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, ...

26.4.4.22 The ps_trace_statement_digest() Procedure

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

8.15.2 System Variables Controlling Tracing

https://dev.mysql.com/doc/refman/5.7/en/system-variables-controlling-tracing.html

end_markers_in_json: If set to 1, causes the trace to repeat the key (if present) near the closing bracket. The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: ...

5.1.13 MySQL Server Time Zone Support

https://dev.mysql.com/doc/refman/5.7/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. For information about time zone ...

12.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html

When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...

Displaying 481 to 490 of 497 total results