Search Results
https://dev.mysql.com/doc/refman/8.4/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row subquery is a subquery variant that returns a single row and can thus return more than one column value. If this row has col3 and col4 values equal to the col1 and col2 ...
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/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/doc/refman/8.4/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using WebAuthn authentication.
https://dev.mysql.com/doc/refman/8.4/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. The following discussion describes how to write ...
https://dev.mysql.com/doc/refman/8.4/en/working-with-null.html
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. In MySQL, 0 or NULL means false and anything else means true. This special ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36301441) Audit log filtering by type, using error as the type, did not work correctly. (Bug #36142157) Following an unplanned shutdown and restart, the file that was in use by the server for writing at the time may be broken or otherwise ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for mysqlbackup. Here is a list of limitations of MySQL Enterprise Backup: In some cases, backups of non-transactional tables such as MyISAM tables could contain ...