PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/storage-engine-setting.html
If the desired engine is unavailable, this setting produces an error instead of a warning, and the table is not created or altered. If a table name contains special characters, the names for the table files contain encoded versions of those ... When ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
If explicit COLLATE Y and COLLATE Z occur, raise an error. MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-is-consumer-enabled.html
If the argument is not a valid consumer name, an error occurs. Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. (Prior to MySQL 8.0.18, the function returns NULL if the argument ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
The MySQL upgrade procedure produces an error if a sys schema exists but has no version view, on the assumption that absence of this view indicates a user-created sys schema. MySQL 8.0 includes the sys schema, a set of objects that helps DBAs and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-analysis.html
err_count The total number of errors produced by occurrences of the statement. The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. db The default database for the statement, or NULL if ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html
err_count The total number of errors produced by occurrences of the statement. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views ...