Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
NdbTransaction::getNdbIndexOperation() Description This method is used to create an NdbIndexOperation associated with a given table. NdbTransaction::getNdbIndexScanOperation() Description This method is used to create an NdbIndexScanOperation ...A ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following options for the CREATE TABLE statement: AUTOEXTEND_SIZE AVG_ROW_LENGTH CHECKSUM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manually and specifying the files to load into the table, you have the option (as of MySQL 9.6.0) to validate a load command before loading data into the external table. This topic contains the following sections: ...Load and Validate Tables Statement To load an external table into MySQL HeatWave Cluster with data from files, specify the SECONDARY_LOAD clause in an ALTER TABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; ...
https://dev.mysql.com/doc/refman/9.7/en/enterprise-encryption-functions.html
create_digest(digest_type, str) Creates a digest from the given string using the given digest type, and returns the digest as a binary string. MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-info.html
Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used in creating a partitioned table. A new row event is created for a modification that takes place in a different ... This section discusses obtaining information about existing partitions, which can be done in a number of ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-routines.html
The following example creates two stored functions getArea() and getDiag(), then creates and runs a JavaScript stored procedure procRect which uses these functions by instantiating them and executing them by means of Function objects. OUT or INOUT ... Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-prepare-a-forecasting-model.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-myisam-fk.html
They are often created for existing databases, to clarify their purpose or document them. MySQL Workbench provides facilities for reverse engineering existing databases, and then creating an EER Diagram automatically. The plugin created in this ...