Search Results
https://dev.mysql.com/doc/refman/8.4/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/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. Collection names are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. The following example creates a collection called flags in the world_x schema. Collection names are ...
https://dev.mysql.com/doc/refman/8.4/en/sys-create-synonym-db.html
Given a schema name, this procedure creates a synonym schema containing views that refer to all the tables and views in the original schema. This can be used, for example, to create a shorter name by which to refer to a schema with a long name ...