PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
The key cache referred to in a CACHE INDEX statement can be created by setting its size with a parameter setting statement or in the server parameter settings. A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE ...| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ...
https://dev.mysql.com/doc/refman/8.0/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
Note Host name identity verification with VERIFY_IDENTITY does not work with self-signed certificates that are created automatically by the server or manually using mysql_ssl_rsa_setup (see Section 8.3.3.1, “Creating SSL and RSA Certificates and ... This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
For a query in which the condition is on the tables of a view created using ALGORITHM=TEMPTABLE instead of on the view itself, the multiple equality is not recognized at resolution, and thus the condition cannot be not pushed down. MySQL 8.0.22 and ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. (By default, a recurring event's schedule ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide information about tables. {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) column. mysql> CREATE TABLE ch (ucs2 CHAR(3) CHARACTER SET ucs2, gb2312 CHAR(3) CHARACTER SET gb2312); In ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html
How are triggers managed in MySQL? Triggers can be created using the CREATE TRIGGER statement, and dropped using DROP TRIGGER. See Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”, for more about ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If this is unsuitable, create ...