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/mysql-cluster-disk-data-objects.html
An extra “NULL row” provides additional information about undo log files. NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects.
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/cast-functions.html
Examples: For conversion of a “zero” date string to a date, CONVERT() and CAST() return NULL and produce a warning when the NO_ZERO_DATE SQL mode is enabled. Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
JSON values are not stored as strings, instead using an internal binary format that permits quick read access to document elements. This function also works with a string that can be parsed as a JSON value. This function also accepts a valid string ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: 100.00 Extra: Using index condition; Using filesort See also Section 8.9.2, “Switchable ... If you need only a specified number of rows from a result set, use a LIMIT clause in the query, rather than fetching the whole result set and throwing away the extra ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
Note In MySQL 5.7, it is possible to match against only a list of integers (and possibly NULL—see Section 22.2.7, “How MySQL Partitioning Handles NULL”) when partitioning by LIST. List partitioning in MySQL is similar to range partitioning in ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
DIGEST The statement digest MD5 value as a string of 32 hexadecimal characters, or NULL if the statements_digest consumer is no. END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning.html
See Section 24.3.16, “The INFORMATION_SCHEMA PARTITIONS Table”, for more information; for some examples of queries against this table, see Section 22.2.7, “How MySQL Partitioning Handles NULL”. Note As of MySQL 5.7.17, the generic ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. Here is a simple example that associates a ...