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/create-event.html
The comment text, being a string literal, must be surrounded by quotation marks. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
Important Under some circumstances, CREATE USER may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that information. An ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
Dictionaries are loaded from plain text files containing one term per line. Prior to MySQL 8.0.19, the functions treat string arguments as binary strings (which means they do not distinguish lettercase), and string return values are binary strings.
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
A valid dictionary file has these characteristics: The file contents are plain text, one term per line. Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.3.1, “MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
(InnoDB compressed tables are readable and writable, while MyISAM compressed tables are read-only.) For MyISAM tables, if you do not have any variable-length columns (VARCHAR, TEXT, or BLOB columns), a fixed-size row format is used. Design your ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
ddl_rewriter examines SQL statements received by the server prior to parsing, rewriting them according to these conditions: ddl_rewriter considers only CREATE TABLE statements, and only if they are standalone statements that occur at the beginning ... MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes ...
https://dev.mysql.com/doc/refman/8.0/en/displaying-traces.html
Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent). INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines.
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
Use the dropdowns for additional filters to select Description—contains, and enter “Docker” in the text field. Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-format.html
Dynamic storage format is used if a MyISAM table contains any variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT), or if the table was created with the ROW_FORMAT=DYNAMIC table option. Dynamic format is a little more complex than static ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
Columns used in comparisons cannot be of any of the BLOB or TEXT types. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such cases, the condition is “pushed down” to the storage ...