Search Results
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
A subquery's outer statement can be any one of: SELECT, INSERT, UPDATE, DELETE, SET, or DO. All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-reset-to-default.html
row *************************** status: Resetting: setup_actors INSERT IGNORE INTO performance_schema.setup_actors VALUES ('%', '%', '%') ... Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure ...
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-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
To enable debug output without having to set that variable in individual sessions, add the option to the table: mysql> INSERT INTO sys.sys_config (variable, value) VALUES('debug', 'ON'); To change the debug setting in the table, do two things. This ...
https://dev.mysql.com/doc/refman/8.4/en/time.html
In particular, any fractional part in a value inserted into a TIME column is stored rather than discarded. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...
https://dev.mysql.com/doc/refman/8.4/en/two-digit-years.html
For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR results in 0000 rather than 2000. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form ...
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/update.html
Note Unlike the case when using PARTITION with an INSERT or REPLACE statement, an otherwise valid UPDATE ... UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table ...