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/sys-statements-with-temp-tables.html
These views list normalized statements that have used temporary tables. The statements_with_temp_tables and x$statements_with_temp_tables views have these columns: query The normalized statement string. By default, rows are sorted by descending ...
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary.html
The user_summary and x$user_summary views have these columns: user The client user name. unique_hosts The number of distinct hosts from which connections for the user have originated. These views summarize statement activity, file I/O, and ...
https://dev.mysql.com/doc/refman/8.0/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/8.0/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
The usual result is “0 rows affected,” which should be interpreted as “no information.” As long as the table definition is valid, the table can be re-created as an empty table with TRUNCATE TABLE, even if the data or index files have become ...Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/two-digit-years.html
To specify zero for YEAR and have it be interpreted as 2000, specify it as a string '0' or '00'. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html
The following instructions assume you have installed MySQL with the MySQL Yum repository or with an RPM package directly downloaded from MySQL Developer Zone's MySQL Download page; if that is not the case, following the instructions in Replacing a ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
LTS releases have 8+ years of support and are meant for production use. Enterprise Support If you're a MySQL Enterprise Edition customer, you can also contact the MySQL Support Team experts with any questions you may have. MySQL supports upgrading ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html
For example, after upgrading from MySQL 5.7 to MySQL 8.0, 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.0/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.