PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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. Important MySQL 8.0 Server requires the ...
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
Regarding passwords, if you installed MySQL using the MySQL Installer, you may have already assigned a password to the initial root account. (You must use those options if you have already secured the initial MySQL accounts.) With -p, the client ...
https://dev.mysql.com/doc/refman/8.0/en/windows-select-server.html
All Windows MySQL 8.0 servers have support for symbolic linking of database directories. It is necessary to enable this variable explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used.
https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html
All products that have a newer version now appear in a list. Prior to MySQL 8.0.16, run mysql_upgrade as Administrator to check your tables, attempt to repair them if necessary, and update your grant tables if they have changed so that you can take ... There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was ...
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
For XA START, the JOIN and RESUME clauses are recognized but have no effect. Also, if GTIDs are enabled, after recovery @@GLOBAL.GTID_EXECUTED might not correctly describe the transactions that have been applied. XA transaction support is limited ...
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
All accounts must have a nonempty User value and literal Host value. Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server ...