Search Results
https://dev.mysql.com/doc/refman/8.4/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. SET column values that consist of multiple set members are specified with members ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Metadata changes occur for DDL statements such as those that create, drop, alter, rename, or truncate tables, or that analyze, optimize, or repair tables. For certain statements that a client might execute multiple times during a session, the ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
The mysql client truncates quoted strings containing NUL characters if they are not escaped, and Control+Z may be taken for END-OF-FILE on Windows if not escaped. A string is a sequence of bytes or characters, enclosed within either single quote ...
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
statement_truncate_len, @sys.statement_truncate_len The maximum length of statements returned by the format_statement() function. Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-views.html
SQL statements are truncated to a maximum display width using format_statement(). The sys schema contains many views that summarize Performance Schema tables in various ways. Most of these views come in pairs, such that one member of the pair has ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Example To create a report with the queries in the 95th percentile since the last truncation of events_statements_summary_by_digest and with a one-minute delta period: Create a temporary table to store the initial snapshot. Creates a report of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
For example, the statement_truncate_len option controls the maximum length of statements returned by the format_statement() function. statement_truncate_len, @sys.statement_truncate_len The maximum length of statements returned by the ... This table ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Check all user-submitted data for type; reject or convert data that is of the wrong type Test numeric data for out of range values; truncate, round, or reject values that are out of range. Table 14.16 XML Functions Name Description ExtractValue() ...