Documents in Tables +------+-----------+-------------+----------+-----------------------------+ 1 row in set (0.00 sec) You can use the  delete()  method to remove some or all records from a table in a database. The X DevAPI provides additional methods to use with the  delete()  method to filter and order the records to be deleted. The following example passes search conditions to the  delete()  method. All records matching the condition are deleted from the city table. In this example, one record matches the condition. mysql-js>  db.city.delete().where("Name = ’Olympia’") To delete the first record in the city table, use the  limit()  method with a value of 1. mysql-js>  db.city.delete().limit(1) You can delete all records in a table. To do so, use the  delete()  method without specifying a search condition. Use care when you delete records without specifying a search condition; doing so deletes all records from the table. The  dropCollection()  method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the  citytest  table from the  world_x  database, issue: mysql-js>  session.dropCollection("world_x", "citytest") In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native  JSON  data type. Examples in this section use the city table in the  world_x  schema. 3863 •See TableUpdateFunction for the full syntax definition. •See TableDeleteFunction for the full syntax definition. •See Section 20.3.2, “Download and Import world_x Database”  for instructions to recreate the  world_x database. Related Information 20.3.4.4 Delete Tables Delete Records Using Conditions Delete the First Record Delete All Records in a Table Caution Drop a Table Related Information 20.3.5 Documents in Tables