Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
Table 5.7 JSON Functions Name Description -> 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/heatwave/en/mys-hw-limitations-joins.html
Antijoins, with the exception of supported IN and EXISTS antijoin variants listed below. EXISTS semijoins and antijoins are supported in the following variants only: SELECT ... NOT EXISTS (...) IS NOT TRUE Depending on transformations and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-row.html
ML_PREDICT_ROW generates predictions for one or more rows of unlabeled data specified in JSON format. A call to ML_PREDICT_ROW can include columns that were not present during ML_TRAIN. A table can include extra columns, and still use the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT routine, which automatically splits your data into training and testing datasets. Two new tables in the same database are created with the following names: [original_table_name]_train ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
The routine also runs the generated SQL statement and displays the result set. You can use this routine for generating and running SQL queries only for databases and tables that you have access to. The routine automatically detects these errors, and ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-blob-clob-processing.html
blobSendChunkSize Chunk size to use when sending BLOB/CLOBs via server-prepared statements. Note that this value cannot exceed the value of 'maxAllowedPacket' and, if that is the case, then this value will be corrected automatically. Since Version ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-jdbc-compliance.html
useColumnNamesInFindColumn Prior to JDBC-4.0, the JDBC specification had a bug related to what could be given as a column name to result set methods like 'findColumn()', or getters that took a String property. JDBC-4.0 clarified "column name" to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-networking.html
socksProxyHost Name or IP address of a SOCKS host to connect through. Default Value 1080 Since Version 5.1.34 socketFactory The name of the class that the driver should use for creating socket connections to the server. This class must implement ...
https://dev.mysql.com/doc/connector-j/en/connector-j-schema-validation.html
When working with MySQL Server 8.0.19 and later: Schema validation can be configured for a Collection, so that documents in the Collection are validated against a schema before they can be inserted or updated. This is done by specifying a JSON ...