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
To show the schema that is assigned to the
global variable, issue
mysql-py> db <Schema:world_x>
If the returned value is not
db variable as follows:
mysql-py> \use world_x Schema `world_x` accessible through db.
To display all relational tables in the
schema, use the
get_tables() method on the
mysql-py> db.get_tables() [ <Table:city>, <Table:country>, <Table:countrylanguage> ]
Basic operations scoped by tables include:
||The insert() method inserts one or more records into the named table.|
||The select() method returns some or all records in the named table.|
||The update() method updates records in the named table.|
||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