PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/performance-schema-ndb-sync-excluded-objects-table.html
row *************************** SCHEMA_NAME: NULL NAME: lg1 TYPE: LOGFILE GROUP REASON: Injected failure *************************** 2. row *************************** SCHEMA_NAME: NULL NAME: ts1 TYPE: TABLESPACE REASON: Injected failure ... This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
row *************************** NAME: thread/performance_schema/setup ENABLED: YES HISTORY: YES PROPERTIES: singleton VOLATILITY: 0 DOCUMENTATION: NULL ... row *************************** NAME: thread/sql/main ENABLED: YES HISTORY: YES PROPERTIES: ...It exposes thread class names and attributes: mysql> SELECT * FROM performance_schema.setup_threads\G *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As of MySQL 8.0.16, MySQL ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/show-table-status.html
Not all storage engines update this time, in which case, the value is always NULL. For views, most columns displayed by SHOW TABLE STATUS are 0 or NULL except that Name indicates the view name, Create_time indicates the creation time, and Comment ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
If all arguments are NULL or the aggregate result is empty, the return value is NULL. The result is the narrowest MultiXxx or GeometryCollection value possible, with the result type determined from the non-NULL geometry arguments as follows: If all ... MySQL supports aggregate functions that perform a calculation on a set of ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-operator-functions.html
See that section for descriptions of these functions: ST_Envelope(g) ST_StartPoint(ls) ST_EndPoint(ls) ST_PointN(ls, N) ST_ExteriorRing(poly) ST_InteriorRingN(poly, N) ST_GeometryN(gc, N) Unless otherwise specified, functions in this section handle ... OpenGIS proposes a number of functions that can produce ...