Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
These variables do not exist outside of stored procedure context, so a statement that refers to such a variable cannot be logged literally. To handle this, MySQL writes a SET statement to the binary log to make sure that the variable exists on the ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
If the file does not exist or cannot be read because one of the preceding conditions is not satisfied, the function returns NULL. mysql> SELECT TO_BASE64('abc'), FROM_BASE64(TO_BASE64('abc')); -> 'JWJj', 'abc' Different base-64 encoding schemes ...
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. To upgrade in this case, remove or rename the existing sys schema first.
https://dev.mysql.com/doc/refman/8.4/en/update.html
Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_references SET assignment_list [WHERE where_condition] For the single-table syntax, the UPDATE statement updates columns of existing rows in the named table with new values. UPDATE is a ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
The same is true if the new version of MySQL implements a built-in function with the same name as an existing stored function. In this case, remove all redo log files and restart the MySQL 8.3 server on the existing data directory to address the ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
To modify the limits for an existing account, use ALTER USER. To modify limits for an existing account, use an ALTER USER statement. One means of restricting client use of MySQL server resources is to set the global max_user_connections system ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
This applies only when changing an existing password, and has no effect when setting a user account's initial password. If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. This ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-mysql.html
The SQL standard has been evolving since 1986 and several versions exist. MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments ... MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the subquery has window functions. Semijoins are not applicable to window function optimization because semijoins apply to ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-single-file.html
Specify a --backup-image value of - (standard output) to stream an existing backup directory structure to a tape device or a command that transfers the backup to another server. Besides the commands for creating and restoring single-file backups ...