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/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.0 to MySQL 5.7, or from a MySQL 8.0 release to a previous MySQL 8.0 release, is not supported.
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
GUI tools exist that perform most of the tasks described in this section, including: MySQL Installer: Used to install and upgrade MySQL products. If necessary, initialize the data directory and create the MySQL grant tables. Windows installation ...
https://dev.mysql.com/doc/refman/8.0/en/windows-start-command-line.html
The MySQL server can be started manually from the command line. To start the mysqld server from the command line, you should start a console window (or “DOS window”) and enter this command: C:\> "C:\Program Files\MySQL\MySQL Server ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
Parentheses eliminate the need to percent encode characters such as the / directory separator character. Important Percent encoding must be used for reserved characters in the elements of the URI-like string. For example, if you specify a string ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
For example, a CHAR(255) column can exceed 768 bytes if the maximum byte length of the character set is greater than 3, as it is with utf8mb4. REDUNDANT Row Format Storage Characteristics The REDUNDANT row format has the following storage ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
--fields-enclosed-by=char Command-Line Format --fields-enclosed-by=char Type String Default Value [none] This works in the same way as the FIELDS ENCLOSED BY option does for the LOAD DATA statement, specifying a character to be interpreted as ...
https://dev.mysql.com/doc/refman/8.0/en/user-names.html
If the user name and password contain only ASCII characters, it is possible to connect to the server regardless of character set settings. To enable connections when the user name or password contain non-ASCII characters, client applications should ... MySQL stores accounts in the user table of the mysql system ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
default_collation_for_utf8mb4: Default collation for utf8mb4 character set; for internal use by MySQL Replication only. print_identified_with_as_hex: For SHOW CREATE USER, print hash values containing unprintable characters in hex. Options and ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
Storage requirements for some data types depend on factors such as storage engine, storage format, and character set. mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), ... This section describes limits on the number of columns in tables and the size of individual ...