https://dev.mysql.com/mysql-shell-tutorial-javascript-documents-collections.html
Each collection has a unique name and exists within a single schema. When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, ...
https://dev.mysql.com/mysql-shell-tutorial-python-collections-operations.html
Collection names are case-sensitive and each collection name must be unique. 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. To show the value that ...
https://dev.mysql.com/mysql-shell-tutorial-python-documents-add.html
The value of the _id field must be unique among all documents in the same collection. To work with the collections in a schema, use the db global object to access the current schema. In this example we are using the world_x schema imported ...
https://dev.mysql.com/mysql-shell-tutorial-python-documents-collections.html
Each collection has a unique name and exists within a single schema. When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, ...
https://dev.mysql.com/mysqladmin.html
You can use it to check the server's configuration and current status, to create and drop databases, and more. Invoke mysqladmin like this: shell> mysqladmin [options] command [command-arg] [command [command-arg]] ... Some of the commands take an ...
https://dev.mysql.com/mysqld-multi.html
For more information on which options must be unique per server in a multiple-server environment, see Section 5.8, “Running Multiple MySQL Instances on One Machine”. mysqld_multi is designed to manage several mysqld processes that listen for ...
https://dev.mysql.com/optimize-numeric.html
For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns. Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less ...
https://dev.mysql.com/parameters-table.html
The return value is not a true parameter, so the row that describes it has these unique characteristics: The ORDINAL_POSITION value is 0. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored ...
https://dev.mysql.com/partitioning-limitations.html
It can be desirable in some cases (see Section 23.6.1, “Partitioning Keys, Primary Keys, and Unique Keys”) to modify a table's primary key. This section discusses current restrictions and limitations on MySQL partitioning support. The following ...
https://dev.mysql.com/partitioning-subpartitions.html
Subpartitioning—also known as composite partitioning—is the further division of each partition in a partitioned table. Consider the following CREATE TABLE statement: CREATE TABLE ts (id INT, purchased DATE) PARTITION BY RANGE( YEAR(purchased) ) ...
