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/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
As of MySQL 5.7.24, MySQL Enterprise Edition provides data masking and de-identification capabilities: Transformation of existing data to mask it and remove identifying characteristics, such as changing all digits of a credit card number but the ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
To minimize space even further by storing table data in compressed form, specify ROW_FORMAT=COMPRESSED when creating InnoDB tables, or run the myisampack command on an existing MyISAM table. Design your tables to minimize their space on the disk.
https://dev.mysql.com/doc/refman/5.7/en/delete.html
For example, to delete rows that exist in t1 that have no match in t2, use a LEFT JOIN: DELETE t1 FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL; The syntax permits .* after each tbl_name for compatibility with Access. DELETE is a DML ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named function_name. (DROP FUNCTION is also used to drop stored functions; see Section 13.1.27, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is ...
https://dev.mysql.com/doc/refman/5.7/en/drop-logfile-group.html
The log file group must already exist or an error results. DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. (For information on creating log file groups, see Section 13.1.15, ...
https://dev.mysql.com/doc/refman/5.7/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
DROP TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. It is supported with all MySQL NDB Cluster 7.5 releases, and with InnoDB in the standard MySQL Server as ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
Note Prior to MySQL 5.7.10, MySQL supports only TLSv1, for both OpenSSL and yaSSL, and no system variable or client option exist for specifying which TLS protocols to permit. MySQL supports multiple TLS protocols and ciphers, and enables ...