MySQL :: MySQL 8.0 Reference Manual :: 20.4.4 Relational Tables

5.7

MySQL 8.0 Reference Manual / ... / Relational Tables

20.4.4 Relational Tables

20.4.4.1 Insert Records into Tables
20.4.4.2 Select Tables
20.4.4.3 Update Tables
20.4.4.4 Delete Tables

You can use MySQL Shell to manipulate not just JSON documents, but also 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 database.

Confirm the Schema

To show the value that is assigned to the schema variable, type db.

mysql-py> db
<Schema:world_x>

If the schema value is not the Schema:world_x database, then set the db variable as follows:

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

Show All Tables

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

mysql-py> db.get_tables()
{
    "city": <Table:city>,
    "country": <Table:country>,
    "countrylanguage": <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 a general overview.
CRUD EBNF Definitions provides a complete list of operations.
See Section 20.4.1, “Import Database Sample” for instructions on setting up the world_x database sample.

PREV HOME UP NEXT