22.4.4 Relational Tables

22.4.4.1 Insert Records into Tables

22.4.4.2 Select Tables

22.4.4.3 Update Tables

22.4.4.4 Delete 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.

Confirm the Schema

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

Press CTRL+C to copy
 
mysql-py> db
<Schema:world_x>

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

Press CTRL+C to copy
 
mysql-py> \use world_x
Schema `world_x` accessible through db.

Show All Tables

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

Press CTRL+C to copy
 
mysql-py> db.get_tables()
[
    <Table:city>,
    <Table:country>,
    <Table:countrylanguage>
]

Basic Table Operations

Basic operations scoped by tables include:

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.

Related Information

• See Working with Relational Tables for more information.

• CRUD EBNF Definitions provides a complete list of operations.

• See Section 22.4.2, “Download and Import world_x Database” for instructions on setting up the world_x schema sample.