Search Results
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/8.4/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/8.4/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/8.4/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/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 ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. What this means is that we can create a Java interface and only use the operations on this interface without any internal knowledge of what the ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-scaffold-example.html
The resulting entities are created and mapped to the tables in the specified database. Scaffolding a Database Using .NET Core CLI Initialize a valid .NET Core project and console application using the .NET Core command-line interface (CLI) and then ... Scaffolding a database produces an Entity Framework model from an existing ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
5.6.7.1.1 ADO: rs.addNew, rs.delete, and rs.update The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. This section contains simple examples of the use of ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-scaffold-example.html
The resulting entities are created and mapped to the tables in the specified database. Scaffolding a Database Using .NET Core CLI Initialize a valid .NET Core project and console application using the .NET Core command-line interface (CLI) and then ... Scaffolding a database produces an Entity Framework model from an existing ...