Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...Because MySQL cannot index JSON values directly, to enable indexing of a collection, you provide a JSON document that specifies the document's fields to be used by the ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. We can verify this behavior by examining the effects on the file system of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
In the illustration below, the single-file backup created in the example given in Section 4.2.2, “Backing Up an Entire MySQL Instance” is restored using the copy-back-and-apply-log command. --backup-dir provides the location of an empty folder ... To restore a MySQL instance from a backup to a database server: Shut down the database ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Description: This error indicates issues such as memory limits, data type range violations, or interruption of the query by the user. Error number: 1042; Symbol: HW_ER_TOPK_QKRN_CREATION Message: Error - failed to process the sort operation with ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
If you prevent the .mysql_history file from being created (see Controlling the History File) and use --histignore="*" to start the mysql client, the interactive history recall facility is disabled fully. The Windows installer creates an item in the ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
EXTENDED If you use the EXTENDED option, MySQL creates the index row by row instead of creating one index at a time with sorting. This option tells MySQL not to trust the information in the .MYI file header and to re-create it using information from ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html
Firewall Rules and Information The Firewall Rules tab lists the active and recorded rules for a given user, the state of each rule, and includes options to add, delete, and save rules. For example, RECORDING rules in MySQL Workbench records the ...