Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-annotation-index.html
4.3.2.5.1 Synopsis @Target(value={java.lang.annotation.ElementType.TYPE, java.lang.annotation.ElementType.FIELD, java.lang.annotation.ElementType.METHOD}) @Retention(value=java.lang.annotation.RetentionPolicy.RUNTIME) public @interface Index { ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
For multi-column keys, the key parameter is an Object[] in which elements correspond to the primary keys in order as defined in the schema. For multi-column primary keys, the key parameter is an Object[], each element of which is a component of the ...Session extends AutoCloseable so it can be used in the try-with-resources ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-clusterj-object-models.html
Comparisons between parameters and database column values can be specified, including equal, greater and less than, between, and in operations. In many cases, a single interface is used; but for cases where different columns are needed by different ... This section discusses the ClusterJ API and the object model used to represent the data handled by the ...
https://dev.mysql.com/doc/x-devapi-userguide/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
function print_result(res) { if (res.hasData()) { // SELECT var columns = res.getColumns(); var record = res.fetchOne(); while (record){ for (index in columns){ print (columns[index].getColumnName() + ": " + record[index] + "\n"); } // Get the next ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
The following JSON functions: JSON_TABLE() queries that include a LEFT JOIN clause require a primary key column specified for the base or intermediate table. A CASE control flow operator or IF() function that contains columns not within an ... As of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
TRAIN_TEST_SPLIT Syntax mysql> CALL sys.TRAIN_TEST_SPLIT ('table_name', 'target_column_name', [options | NULL]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['task', ... MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT ...
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-effect.html
The first column shows the result of the SELECT using the Swedish/Finnish collating rule, which says that U-umlaut sorts with Y. The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The ...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/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...