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/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
If you set a TLS version parameter to the empty string, encrypted connections cannot be established: tls_version: The server does not permit encrypted incoming connections. MySQL supports multiple TLS protocols and ciphers, and enables configuring ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time ...
https://dev.mysql.com/doc/refman/5.7/en/gis-geometrycollection-property-functions.html
If any argument is NULL or the geometry argument is an empty geometry, the return value is NULL. mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); ...GeometryN() is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored both in the .frm files, and in the InnoDB data dictionary. If you move .frm files around, or if the server crashes in the middle of a data dictionary operation, these sources of information can become ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-introduction.html
MySQL uses the default collation for this character set (utf8_general_ci) for all searches, sorts, comparisons, and other string operations on such columns. Because some MySQL objects are represented as files, searches in INFORMATION_SCHEMA string ... INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...For example, in contexts where MySQL expects a date, it interprets any of '2015-07-21', '20150721', and 20150721 as a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbd.html
--bind-address Command-Line Format --bind-address=name Type String Default Value Causes ndbd to bind to a specific network interface (host name or IP address). --connect-string Command-Line Format --connect-string=connection_string Type String ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
If the FIELDS ESCAPED BY character is empty, no characters are escaped and NULL is output as NULL, not \N. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be ...