PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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.
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 ...