Movatterモバイル変換

The example that follows passes search conditions to thedelete() method. All records matching the condition are deleted from thecity table. In this example, one record matches the condition.

mysql-py> db.city.delete().where("Name = 'Olympia'")

To delete the first record in the city table, use thelimit() method with a value of 1.

mysql-py> db.city.delete().limit(1)

You can delete all records in a table. To do so, use thedelete() method without specifying a search condition.

Thedrop_collection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop thecitytest table from theworld_x database, issue:

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