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/comp-err.html
--charset=dir_name, -C dir_name Command-Line Format --charset Type String Default Value ../share/charsets The character set directory. comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
These are guidelines for the primary key, followed by more detailed explanations. If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Note ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
SELECT, the destination table does not preserve information about whether columns in the selected-from table are generated columns. The SELECT part of the statement cannot assign values to generated columns in the destination table. SELECT, the ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
Randomly generated passwords are available as of MySQL 8.0.18 and have the characteristics described in Random Password Generation. The latter corresponds to the type of value displayed by SHOW CREATE USER for password hashes containing unprintable ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
Automatic SSL and RSA File Generation Manual SSL and RSA File Generation Using mysql_ssl_rsa_setup SSL and RSA File Characteristics Automatic SSL and RSA File Generation For MySQL distributions compiled using OpenSSL, the MySQL server has the ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html
These files, one per database directory, contained database default character set attributes. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with file-based metadata storage included expensive file scans, ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
ALTER TABLE tbl_name ENGINE=engine_name fails because it updates the storage engine designation, which is stored in the data dictionary. If a query result must have specific row ordering characteristics, include an ORDER BY clause. Previously, ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components-vs-plugin.html
Prior to 8.0.33, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure in MySQL 8.0.33. The following table briefly compares MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking.html
MySQL Enterprise Edition provides data masking and de-identification capabilities: Transformation of existing data to mask it and remove identifying characteristics, such as changing all digits of a credit card number but the last four to 'X' ...