Search Results
https://dev.mysql.com/doc/refman/8.4/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. When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/en/string-type-syntax.html
A string object that can have only one value, chosen from the list of values 'value1', 'value2', ..., NULL or the special '' error value. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL ...
https://dev.mysql.com/doc/refman/8.4/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. This function accounts for the consumer hierarchy, so a consumer ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4 includes the sys schema, a set of objects that helps DBAs and ...
https://dev.mysql.com/doc/refman/8.4/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 ...