Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/create-library.html
CREATE LIBRARY [IF NOT EXISTS] [database.]library LANGUAGE language [COMMENT "comment_text"] AS code This statement creates a library in the named database, if any. If no database is specified, the library is created in the current database. code ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/data-masking-plugin-functions.html
Dictionaries are loaded from plain text files containing one term per line. The MySQL Enterprise Data Masking plugin library includes several functions, which may be grouped into these categories: Data Masking Plugin Functions Random Data ...
https://dev.mysql.com/doc/refman/9.7/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, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 9.7 includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes ...