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.
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.
mysql-py> db.get_tables()
[
<Table:city>,
<Table:country>,
<Table:countrylanguage>
]
Basic operations scoped by tables include:
| Operation form | Description |
|---|---|
db. | The insert() method inserts one or more records into the named table. |
db. | The select() method returns some or all records in the named table. |
db. | The update() method updates records in the named table. |
db. | The delete() method deletes one or more records from the named table. |
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.