Relational Tables •See Defining an Index for more information on the JSON document that defines an index. •See Collection Index Management Functions for the full syntax definition. •See Working with Relational Tables for more information. •CRUD EBNF Definitions provides a complete list of operations. •See Section 20.4.2, “Download and Import world_x Database”  for instructions on setting up the  world_x schema sample. Related Information 20.4.4.1 Insert Records into Tables Basic Table Operations 20.4.4 Relational Tables Confirm the Schema Show All Tables You can also use X DevAPI to work with relational tables. In MySQL, each relational table is associated with a particular storage engine. The examples in this section use  InnoDB  tables in the  world_x  schema. To show the schema that is assigned to the  db  global variable, issue  db . If the returned value is not  Schema:world_x , set the  db  variable as follows: To display all relational tables in the  world_x  schema, use the  get_tables()  method on the  db  object. Basic operations scoped by tables include: 3879 mysql-py>  db <Schema:world_x> mysql-py>  \use world_x Schema ‘world_x‘ accessible through db. mysql-py>  db.get_tables() [ <Table:city>, <Table:country>, <Table:countrylanguage> ] Operation form Description db. name .insert() The insert() method inserts one or more records into the named table. db. name .select() The select() method returns some or all records in the named table. db. name .update() The update() method updates records in the named table. db. name .delete() The delete() method deletes one or more records from the named table.