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/enterprise-encryption-function-reference.html
Table 6.36 MySQL Enterprise Encryption Functions Name Description asymmetric_decrypt() Decrypt ciphertext using private or public key asymmetric_derive() Derive symmetric key from asymmetric keys asymmetric_encrypt() Encrypt cleartext using private ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-general.html
(However, the query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0.) The query cache operates on the server level, caching complete result sets matched with the original query string. Does MySQL 5.7 have a Query Cache? Does it ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
This is simply an instance of MySQL Server (mysqld) that is built with support for the NDBCLUSTER storage engine and started with the --ndb-cluster option to enable the engine and the --ndb-connectstring option to enable it to connect to an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL ...
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
Instead, the table definition includes a connection string that points to the remote table. When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the ...
https://dev.mysql.com/doc/refman/5.7/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...
https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
Previously, the temporal type keyword was ignored and these constructs produced the string value. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
For example: CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; The file base name depends on your platform. Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports automatic ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
File system case sensitivity can affect searches in string columns of INFORMATION_SCHEMA tables. In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the ...