PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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. For information about features as they are introduced into MySQL on a series-specific ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collations-table.html
SORTLEN This is related to the amount of memory required to sort strings expressed in the character set. The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which ...