Database structure

As a refresher, here's the structure of our database at the end of the first session.

SHOW TABLES;

Tables_in_tutorial cheese people

DESCRIBE cheese;

Field Type Null Key Default Extra id int(10) unsigned NO PRI   auto_increment name varchar(64) NO       country char(2) NO

DESCRIBE people;

Field Type Null Key Default Extra email varchar(64) NO PRI     name varchar(128) NO       dob date YES       fave_cheese int(10) unsigned NO

There was also some data in the tables. You can download the database dump to create a clone of this database. In a UN*X environment, just save the dump and redirect it into mysql, like so:

shell> mysql -u username -p database < dbdump.sql

Return to tutorial