Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbeventoperation.html
Changed attribute values may be retrieved after Ndb::nextEvent() has returned a value other than NULL. Before attempting to use this method, you should have read the explanations provided in Ndb::nextEvent() (DEPRECATED), and ... This section ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) Description MySQL implements a session tracker mechanism whereby the server returns information about session state changes to ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Return value: The password string for success (up to 766 bytes), or NULL and an error for failure. Each element in the returned array is an event represented as a JSON hash, with the exception that the last element may be a JSON null value to ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-reference.html
| +------------------------------------+ An argument of NULL is treated as an empty string, which has no effect on the token list. (It is not an error to delete nonexisting tokens.) To clear the token list entirely without knowing which tokens are ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1057; Symbol: HW_ER_UNEXPECTED_NULL_JOIN Message: Root-level UNION ALL - unexpected NULL JOIN under STREAM Access Path. Workaround: Equality or NULL-safe equality should be present in the JOIN predicate. Error number: 1113; Symbol: ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
For RANGE, the bound is the rows with values equal to the current row value minus expr; if the current row value is NULL, the bound is the peers of the row. For RANGE, the bound is the rows with values equal to the current row value plus expr; if ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
The following rules describe how conversion occurs for comparison operations: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe <=> equality comparison operator. When an operator is used with operands ...
https://dev.mysql.com/doc/refman/8.4/en/reset-binary-logs-and-gtids.html
Note This statement takes the place of the old RESET MASTER statement, which is no longer supported. RESET BINARY LOGS AND GTIDS [TO binary_log_file_index_number] Warning Use this statement with caution to ensure you do not lose any wanted binary ...
https://dev.mysql.com/doc/refman/8.4/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 ...