PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
mysql-js> db.countryinfo.createIndex("name", {"fields": [{"field": "$.Name", "type": "TEXT(40)", "required": true}], "unique": true}) Drop an Index To drop an index, pass the name of the index to drop to the dropIndex() method. For example, you can ... Indexes are used to find documents with specific field values ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-collections-operations.html
mysql-py> db.get_collections() [ <Collection:countryinfo>, <Collection:flags> ] Drop a Collection To drop an existing collection from a schema, use the db object's drop_collection() method. For example, to drop the flags collection from the current ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
mysql-py> db.countryinfo.create_index("name", {"fields": [{"field": "$.Name", "type": "TEXT(40)", "required": True}], "unique": True}) Drop an Index To drop an index, pass the name of the index to drop to the drop_index() method. For example, you ...
https://dev.mysql.com/doc/refman/8.0/en/sys-list-drop.html
Removes a value from a comma-separated list of values and returns the result. For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified.
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Disabling foreign_key_checks has these additional implications: It is permitted to drop a database that contains tables with foreign keys that are referenced by tables outside the database. The CONSTRAINT symbol value, if defined, must be unique in ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable ...
https://dev.mysql.com/doc/refman/8.0/en/roles.html
Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles Revoking Roles or Role Privileges Dropping Roles User and Role Interchangeability Creating Roles and Granting Privileges to Them ...The ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
Important For statement-based logging, an exception is made in the rules just given for the CREATE DATABASE, ALTER DATABASE, and DROP DATABASE statements. In those cases, the database being created, altered, or dropped replaces the default database ...The database that is checked for a match depends on the binary log format of the statement that is being ... When evaluating replication options, the replica ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
An undo tablespace not found before recovery cannot be used, which can lead to database inconsistencies. As of MySQL 8.0.14, undo tablespaces can be dropped using DROP UNDO TABALESPACE syntax. Dropping Undo Tablespaces As of MySQL 8.0.14, undo ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...