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/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/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/assignment-operators.html
Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/5.7/en/date-calculations.html
You determine which animals these are by checking whether the death value is NULL. MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
Example 14.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate count of pages that contain system data by excluding pages where the TABLE_NAME value is either NULL or includes a slash / or period . The InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-config.html
The value is NULL if the row has not been changed since the sys schema was installed. (For example, the variable corresponding to the diagnostics.include_raw option is @sys.diagnostics.include_raw.) If the user-defined variable exists in the current ... This table contains sys schema configuration options, one row per ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-string Command-Line Format --connect-string=connection_string Type String Default ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
mysqlx_ssl_cipher Command-Line Format --mysqlx-ssl-cipher=name System Variable mysqlx_ssl_cipher Scope Global Dynamic No Type String Default Value NULL The mysqlx_ssl_cipher system variable is like ssl_cipher, except that it applies to X Plugin ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. The union of two GTID sets is simply their representations as strings, joined together with an interposed comma. The GTID sets used ...