content_image/669438.jpg
•See Defining an Index for more information on the JSON document that defines an index. 

## 20.4.4 Relational Tables 

•See Collection Index Management Functions for the full syntax definition. 

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. 

## Confirm the Schema 

## Show All Tables 

To show the schema that is assigned to the db  global variable, issue db . 

mysql-py> db <Schema:world_x> 

If the returned value is not Schema:world_x , set the db  variable as follows: 

mysql-py> \use world_x Schema ‘world_x‘ accessible through db. 

To display all relational tables in the world_x  schema, use the get_tables()  method on the db  object. 

## Basic Table Operations 

mysql-py> db.get_tables() [ <Table:city>, <Table:country>, <Table:countrylanguage> ] 

Basic operations scoped by tables include: 

<img src='content_image/669438.jpg'>

## Related Information 

•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. 

## 20.4.4.1 Insert Records into Tables 

