Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave AutoML. Prepare Datasets Create and use the the database ml_data to store the table of data. mysql> CREATE SCHEMA ...It ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables. Review the following examples for different ways to create external tables. These ...To learn more, see Load Structured Data Using Lakehouse Auto Parallel ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-secondary-indexes.html
A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns. When a secondary index is created on a virtual generated column, generated column values are ...A ...
https://dev.mysql.com/doc/refman/9.7/en/json-duality-views-syntax.html
The CREATE JSON RELATIONAL DUALITY VIEW statement is an extension of the CREATE VIEW statement. There are some additional clauses with CREATE JSON RELATIONAL DUALITY VIEW, and some restrictions on the SELECT statement. The result set is structured ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-key-partitioning.html
As of MySQL 9.6.1, you can specify the PARTITION BY KEY option in the CREATE EXTERNAL TABLE statement. Before You Begin Review how to Create an External Table Manually. mysql> CREATE EXTERNAL TABLE table_1 ( col_1 int, col_2 int, _metadata_filename ...Overview For structured and semi-structured data, the column specified for key partitioning must be a metadata column, or a generated column over a metadata ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-crystal-source.html
When creating a report in Crystal Reports there are two options for accessing the MySQL data while designing your report. The second option is to create a data set in VB.NET and save it as XML. This works quite well when displaying the report in ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-crystal-source.html
When creating a report in Crystal Reports there are two options for accessing the MySQL data while designing your report. The second option is to create a data set in VB.NET and save it as XML. This works quite well when displaying the report in ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-index.html
If a collection is large and queries on a specific field are common, then consider creating an index on a specific field inside a document. For example, the following query performs better with an index on the Population field: mysql-py> ... Indexes ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-non-committing-statements.html
Let S be a logged statement that does not have an implicit commit, except CREATE TEMPORARY TABLE...SELECT (This includes all "pure DML": INSERT, UPDATE, DELETE, REPLACE, TRUNCATE, SELECT, DO, CALL, EXECUTE, LOAD DATA INFILE, and BINLOG. It also ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-tables.html
You can create the employee table that matches this interface, using the following CREATE TABLE statement, in a MySQL client application such as mysql. ClusterJ's main purpose is to read, write, and update row data in an existing database, rather ...