Movatterモバイル変換

To show the value that is assigned to the schema variable, issue:

mysql-py> db

If the schema value is notSchema:world_x, then set thedb variable by issuing:

mysql-py> \use world_x

To create a new collection in an existing schema, use thedb object'screateCollection() method. The following example creates a collection calledflags in theworld_x schema.

mysql-py> db.create_collection("flags")

The method returns a collection object.

<Collection:flags>

To display all collections in theworld_x schema, use thedb object'sget_collections() method. Collections returned by the server you are currently connected to appear between brackets.

mysql-py> db.get_collections()[    <Collection:countryinfo>,    <Collection:flags>]

To drop an existing collection from a schema, use thedb object'sdrop_collection() method. For example, to drop theflags collection from the current schema, issue:

mysql-py> db.drop_collection("flags")

Thedrop_collection() method is also used in MySQL Shell to drop a relational table from a schema.