Search Results
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...
https://dev.mysql.com/doc/refman/8.4/en/two-digit-years.html
Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates ...
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/upgrade-binary-package.html
A MySQL Cluster upgrade can be performed as a regular rolling upgrade, following the usual three ordered steps: Upgrade MGM nodes. This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
When Step 2 is upgrading the system tables in the mysql schema, the column order in the primary key of the mysql.db, mysql.tables_priv, mysql.columns_priv and mysql.procs_priv tables is changed to place the host name and user name columns together.
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. This limits the number of simultaneous connections that can be made by any given account, but places no ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
Order of tokens is not significant except that if a token list contains multiple instances of a given token name, the last value takes precedence over earlier values. Before using Version Tokens, install it according to the instructions provided at ...
https://dev.mysql.com/doc/refman/8.4/en/window-function-optimization.html
The optimizer processes multiple windows that have the same ordering requirements in sequence, so sorting can be skipped for windows following the first one. Window functions affect the strategies the optimizer considers: Derived table merging for ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
If both --defaults-file and --local-service are given following the service name, they can be in any order. On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-options-system-variables.html
The algorithm names deflate_stream, lz4_message, and zstd_stream can be specified in any combination, and the order and case are not important. To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format ...