Search Results
https://dev.mysql.com/doc/refman/8.4/en/comp-err.html
It compiles the errmsg.sys file from text-format error information in MySQL source distributions: The error information comes from the messages_to_error_log.txt and messages_to_clients.txt files in the share directory. comp_err creates the ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
--protocol={TCP|SOCKET|PIPE|MEMORY} Command-Line Format --protocol=type Type String Default Value [see text] Valid Values TCPSOCKETPIPEMEMORY This option explicitly specifies which transport protocol to use for connecting to the server. This ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT columns), you can try to change all VARCHAR to CHAR with ALTER TABLE. Each MySQL version is tested on many platforms before it ...
https://dev.mysql.com/doc/refman/8.4/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 {REPLICA | SLAVE}] [COMMENT ...
https://dev.mysql.com/doc/refman/8.4/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.4/en/data-masking-plugin-functions.html
Dictionaries are loaded from plain text files containing one term per line. The MySQL Enterprise Data Masking and De-Identification plugin library includes several functions, which may be grouped into these categories: Data Masking Plugin Functions ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...
https://dev.mysql.com/doc/refman/8.4/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.4 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes ...