Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-master-status.html
This statement is no longer supported, and has been replaced by SHOW BINARY LOG STATUS.
https://dev.mysql.com/doc/refman/8.4/en/signal.html
The message text and error number set by the warning are replaced by the values set by the error, which are returned with the error information. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, ...
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
Instead, each reference to a local variable is replaced by this construct for logging purposes: NAME_CONST(var_name, var_value) var_name is the local variable name, and var_value is a constant indicating the value that the variable has at the time ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
Replace a comparison that looks like this: outer_expr [NOT] IN (SELECT inner_expr FROM ...) with this expression: (outer_expr IS NOT NULL) AND (outer_expr [NOT] IN (SELECT inner_expr FROM ...)) Then NULL IN (SELECT ...) is never evaluated because ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links.html
You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-statement.html
Otherwise, the middle part of the string is replaced by an ellipsis (...). Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. This ...
https://dev.mysql.com/doc/refman/8.4/en/sys-metrics.html
This view summarizes MySQL server metrics to show variable names, values, types, and whether they are enabled. The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...