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/heatwave/en/mys-hwaml-model-sharing.html
This topic describes how to grant other users access to a model you create. Before You Begin Share Your Models Export the Model to Share Set Up Other User with Required Privileges Import Shared Model Run AutoML Routines on Imported Model What's ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
If you do not know ahead of time whether the SQL statement will be a SELECT or an UPDATE/INSERT, then you can use the execute(String SQL) method. This method will return true if the SQL query was a SELECT, or false if it was an UPDATE, INSERT, or ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-attribute-tables-mysqld.html
Ndb_conflict_fn_max_ins: Number of times that NDB replication conflict resolution based on "greater timestamp wins" has been applied to insert operations. Ndb_conflict_fn_max_del_win_ins: Number of times that NDB replication conflict resolution ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-29.html
(Bug #106065, Bug #33726184) When inserting BigDecimal values into a database using rewritable server-side prepared statements with cursor-based fetching, the values suffered precision loss. (Bug #104349, Bug #33563548) When the connection property ... Version 8.0.29 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. Truncation of excess trailing spaces from values to be inserted into TEXT columns always ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. It is a case-insensitive ...