Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON array JSON_CONTAINS() Whether JSON document contains specific object at path. JSON_DEPTH() Maximum depth of JSON document ...Table ...
https://dev.mysql.com/doc/refman/8.4/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
HANDLER statement had not been present, MySQL would have taken the default action (EXIT) after the second INSERT failed due to the PRIMARY KEY constraint, and SELECT @x would have returned 2. statement handler_action: { CONTINUE | EXIT | UNDO } ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
Files are typically divided into fixed-size blocks that are compressed into variable-size blocks, which easily leads into fragmentation. Updates and inserts of small records may be written to this modification log without requiring the entire page ... This section describes some internal implementation details about compression for InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlock-example.html
Client A enables innodb_print_all_deadlocks, creates two tables, 'Animals' and 'Birds', and inserts data into each. The following example illustrates how an error can occur when a lock request causes a deadlock. Thererfore, the previous read-only ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
The change buffer is not used, because there are no random-access inserts into the secondary indexes. The next row inserted into the table uses the specified value for its auto-increment column. The newly created table includes any changes applied ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.4/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
Initially, mysql executes statements in the input because specifying a database db_name on the command line is equivalent to inserting USE db_name at the beginning of the input. The INSERT and CREATE TABLE statements are executed because the default ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...