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-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Beginning ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). 5.7.13 / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-plugin-information.html
Any that have a PLUGIN_LIBRARY value of NULL are built in and cannot be unloaded. row *************************** PLUGIN_NAME: binlog PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 50158.0 PLUGIN_LIBRARY: ... There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded ...
https://dev.mysql.com/doc/refman/5.7/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/5.7/en/outer-join-optimization.html
If there is a row in A that matches the WHERE clause, but there is no row in B that matches the ON condition, an extra B row is generated with all columns set to NULL. For a LEFT JOIN, if the WHERE condition is always false for the generated NULL ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Unlike the case with other partitioning types, columns used for partitioning by KEY are not restricted to integer or NULL values. Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Not all storage engines update this time, in which case, the value is always NULL. For views, all columns displayed by SHOW TABLE STATUS are NULL except that Name indicates the view name and Comment says VIEW. SHOW TABLE STATUS [{FROM | IN} ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
While a NULL itself does not require any storage space, NDB reserves 4 bytes per row if the table definition contains any columns defined as NULL, up to 32 NULL columns. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type ...
https://dev.mysql.com/doc/refman/5.7/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...