https://dev.mysql.com/string-comparison-functions.html
Table 12.8 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 resulting ...
https://dev.mysql.com/sys-ps-thread-stack.html
Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...
https://dev.mysql.com/sys-ps-truncate-all-tables.html
mysql> CALL sys.ps_truncate_all_tables(FALSE); +---------------------+ | summary | +---------------------+ | Truncated 49 tables | +---------------------+ . Truncates all Performance Schema summary tables, resetting all aggregated instrumentation ...
https://dev.mysql.com/upgrading-from-previous-series.html
Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation and applications. Changes marked as Incompatible change are incompatibilities with earlier versions of ...
https://dev.mysql.com/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...
https://dev.mysql.com/views-table.html
You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. VIEW_DEFINITION ...
https://dev.mysql.com/with.html
The optimizer cannot predict the number of iterations because it cannot predict when the WHERE clause will become false. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can ...
https://dev.mysql.com/working-with-null.html
In MySQL, 0 or NULL means false and anything else means true. The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. This special ...
https://dev.mysql.com/writing-password-validation-plugins.html
This section describes how to write a server-side password-validation plugin. The instructions are based on the source code in the plugin/password_validation directory of MySQL source distributions. The validate_password.cc source file in that ...
