Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
For example, after upgrading from MySQL 8.3 to MySQL 8.4, you may notice that tables no longer have .frm files. Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
Changed Server Defaults This section contains information about MySQL server system variables whose default values have changed in MySQL 8.4 as compared to MySQL 8.0. Before upgrading to MySQL 8.4, review the changes described in the following ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
If you have a user created sys schema, this must be renamed for the upgrade to succeed. Step 2 upgrades the system tables to ensure that they have the current structure, and this includes the help tables but not the time zone tables. Installing a ...
https://dev.mysql.com/doc/refman/8.4/en/using-innodb-tables.html
For example, in a table containing information about people, you would not create a primary key on (firstname, lastname) because more than one person can have the same name, a name column may be left blank, and sometimes people change their names.
https://dev.mysql.com/doc/refman/8.4/en/verifying-md5-checksum.html
After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. If you have OpenSSL installed, you can use the command openssl md5 package_name instead. Each package has an ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
CHECK TABLE can be used to check for views that have been invalidated by DROP or ALTER operations. Views do not have indexes, so index hints do not apply. The maximum number of tables that can be referenced in the definition of a view is 61. View ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Depending on the device, you may have to perform gesture action multiple times. Depending on the device, you may have to perform gesture action multiple times. Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a ...
https://dev.mysql.com/doc/refman/8.4/en/where-optimization.html
This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
Aggregate functions used as window functions operate on rows in the current row frame, as do these nonaggregate window functions: FIRST_VALUE() LAST_VALUE() NTH_VALUE() Standard SQL specifies that window functions that operate on the entire ... The ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
These include, but are not limited to: To connect to the MySQL server using ODBC, you must have a Connector/ODBC driver. To use MySQL server with .NET applications, you must have the Connector/NET driver. MySQL is available for Microsoft Windows ...