Search Results
https://dev.mysql.com/doc/c-api/9.7/en/mysql-stmt-num-rows.html
For statements such as INSERT, UPDATE, or DELETE, the number of affected rows can be obtained with mysql_stmt_affected_rows(). uint64_t mysql_stmt_num_rows(MYSQL_STMT *stmt) Description Returns the number of rows in the result set. The use of ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-model-catalog.html
ML_TRAIN inserts the model as a row in the MODEL_CATALOG table at the end of training. AutoML creates a model catalog for any user that creates a machine learning model. The MODEL_CATALOG table is created in a schema named ML_SCHEMA_user_name, where ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/9.7/en/news-9-5-0.html
(Bug #38260769) When running CREATE or INSERT statements on a NDB Binlog server with sql_log_bin = 0, replication would fail due to a table not existing. MySQL NDB Cluster 9.5.0 is a new Innovation release of NDB Cluster, based on MySQL Server 9.6 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
SELECT sum(l_quantity) from lineitem limit 1000 INTO OUTFILE WITH PARAMETERS '{"file":[{ "uri":"oci://bucket_1@tenancy1/data_files_1/"}], "dialect": {"format": "json" } }'; Example for PAR URL The following example uses a specific PAR URL to export ... The option to export query results as an ND-JSON file is available as of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. Models in ONNX format (.onnx) cannot be loaded directly into a MySQL table. Before running ML_MODEL_IMPORT, follow the instructions in Import an External ONNX ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-heatwave-estimate-cluster-size.html
If you have not loaded data into your DB System, and you want to estimate the optimal MySQL HeatWave Cluster size, load data into the DB System before you create a MySQL HeatWave Cluster. Prerequisites: The data you intend to load into the MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-workspace-managing-hw-data.html
Data is loaded into MySQL HeatWave from the associated DB System. If you have not loaded data into the DB System, see Importing Data. The source data is read from an Amazon S3 bucket, transformed into a memory-optimized format, stored in the MySQL ...Creating Lakehouse Data Mapping: MySQL HeatWave Lakehouse enables query processing on the data residing in an Amazon S3 ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-create-configure.html
The import status and its effects on newcluster and its cluster processes persist until we have completed importing another cluster into newcluster. After the successful dry run, you are now ready to import the wild cluster's configuration into ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-functions.html
On server2, extract that statement from the mysqldump output, and store the GTID set into a local variable, such as $gtid_purged_set. To check, on server1, extract and store gtid_purged from the output into a local variable as done previously, then ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/9.7/en/semijoins-antijoins.html
The following subqueries are transformed into antijoins: NOT IN (SELECT ... IN (SELECT ...)) IS NOT TRUE can be transformed into antijoins. Materialize the subquery into an indexed temporary table that is used to perform a join, where the index is ... A semijoin is a preparation-time transformation that enables multiple execution strategies such as table pullout, duplicate weedout, first match, loose scan, and ...