Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
A UNIQUE index over a NOT NULL column could be used instead of a primary key and the same functional dependence would apply. As with the previous example, a UNIQUE key over NOT NULL columns could be used instead of a primary key. If in the join ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-trx-table.html
TRX_REQUESTED_LOCK_ID The ID of the lock the transaction is currently waiting for, if TRX_STATE is LOCK WAIT; otherwise NULL. TRX_WAIT_STARTED The time when the transaction started waiting on the lock, if TRX_STATE is LOCK WAIT; otherwise NULL. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. If an event is produced from an instrument that has TIMED = NO, timing information is not collected, and TIMER_START, ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
row *************************** Db: myschema Name: e_daily Definer: jon@ghidora Time zone: SYSTEM Type: RECURRING Execute at: NULL Interval value: 1 Interval field: DAY Starts: 2018-08-08 11:06:34 Ends: NULL Status: ENABLED Originator: 1 ... SHOW ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
(Observe that it could have a match, were the operator a null-safe equals <=>). Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM ...
https://dev.mysql.com/doc/ndbapi/en/ndb-event.html
Return value The table with which the event is associated—if there is one—as a pointer to a Table object; otherwise, this method returns NULL. Signature void setTable ( const NdbDictionary::Table& table ) You can also use a pointer with this ...
https://dev.mysql.com/doc/refman/8.4/en/gis-polygon-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_Centroid() handles its arguments as described in ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-mbr.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or an empty geometry, the return value is NULL. MBREquals() handles its arguments as described in the introduction to this ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_valid_donor_list Command-Line Format --clone-valid-donor-list=value System Variable clone_valid_donor_list Scope Global Dynamic Yes SET_VAR Hint Applies No Type String Default Value NULL Defines valid donor host addresses for remote cloning ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-modify.html
The modify(SearchConditionStr) function is for modifying documents in a collection, similar to an UPDATE statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that are to be ...