PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-restrictions.html
The use of ENCRYPT() with these character sets is not recommended because the underlying system call expects a string terminated by a zero byte. Identifiers are stored in mysql database tables (user, db, and so forth) using utf8, but identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb3.html
utf8mb3 can be used in CHARACTER SET clauses, and utf8mb3_collation_substring in COLLATE clauses, where collation_substring is bin, czech_ci, danish_ci, esperanto_ci, estonian_ci, and so forth. For example: mysqld --character-set-server=utf8mb3 SET ... The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html
The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP ...
https://dev.mysql.com/doc/refman/5.7/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...A ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. In standard MySQL 5.7 releases, this is always an InnoDB tablespace. MySQL NDB Cluster 7.5 also supports tablespaces using the NDB storage engine in addition to those using InnoDB.
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
This may include genetic sequences (long strings), test results stored in JSON format, and other data types. Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial product. As of ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
If it is very likely that a long string column has a unique prefix on the first number of characters, it is better to index only this prefix, using MySQL's support for creating an index on the leftmost part of the column (see Section 13.1.14, ...
https://dev.mysql.com/doc/refman/5.7/en/datetime.html
Be aware of certain properties of date value interpretation in MySQL: MySQL permits a “relaxed” format for values specified as strings, in which any punctuation character may be used as the delimiter between date parts or time parts. This ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-server.html
Global information, that is, the connection ID and user/host and where relevant the query string, is provided at key levels (connection-start, command-start, query-start, and query-exec-start). Support for DTrace is deprecated in MySQL 5.7 and is ...
https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html
SQLSTATE [VALUE] sqlstate_value: A 5-character string literal indicating an SQLSTATE value. DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION ...