PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-national.html
For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As are these: VARCHAR(10) CHARACTER SET utf8 NATIONAL VARCHAR(10) NVARCHAR(10) NCHAR VARCHAR(10) NATIONAL CHARACTER VARYING(10) ...
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/charset.html
The default MySQL server character set and collation are latin1 and latin1_swedish_ci, but you can specify character sets at the server, database, table, column, and string literal levels. MySQL includes character set support that enables you to ...
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/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/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 ...