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 copymysql-py> db <Schema:world_x>
If the returned value is not Schema:world_x
,
set the db
variable as follows:
Press CTRL+C to copymysql-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 copymysql-py> db.get_tables() [ <Table:city>, <Table:country>, <Table:countrylanguage> ]
Basic Table Operations
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. |
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.