Search Results
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/workbench/en/wb-what-is-new-60.html
Figure 1.36 Comparing the SQL Editor interface for Workbench 5.2 and 6.0 Table Data Search You can select schemas, tables, or both to perform client-side searches for user specified strings and patterns. Figure 1.41 Cascading SELECT Table Templates ... This section summarizes many of the new features added to MySQL Workbench 6.0, in relation to the MySQL Workbench 5.2 ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
It is used by the MySQL Workbench Migration Wizard to copy data after the schema is migrated and created in the target MySQL server. It uses the same syntax as the MySQL Utilities: For TCP/IP connections: username[:password]@host:port For local ...
https://dev.mysql.com/doc/connectors/en/connector-j-source-replica-replication-connection.html
Users may specify the property allowReplicasDownConnections=true to allow Connection objects to be created even though no replica hosts are reachable. This enables users to promote replicas for Java applications without requiring an application ...
https://dev.mysql.com/doc/connector-net/en/preface.html
MySQL Connector/NET 9.4 Community License Information User Manual has information about licenses relating to Connector/NET community releases in the 9.4 release series. MySQL Connector/NET 9.4 Commercial License Information User Manual has ...
https://dev.mysql.com/doc/mysql-installer/en/preface.html
If you are using a Commercial release of MySQL Installer, see the MySQL Installer Commercial License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-mysql-instances-permissions.html
Read-Only: access to the MySQL instances, but no rights to create, modify, or delete connections to those instances. Administer: access to the MySQL instances, and can create, modify, and delete connections to those servers. To install SYS schema ...
https://dev.mysql.com/doc/connector-j/en/connector-j-source-replica-replication-connection.html
Users may specify the property allowReplicasDownConnections=true to allow Connection objects to be created even though no replica hosts are reachable. This enables users to promote replicas for Java applications without requiring an application ...