Lab for CPSC 370K
Use mysql on rosemary.mwc.edu to
Create the tables described in Figures 8.1 and 8.2 of the materials distributed about
databases.
The SQL you need to use is given on pages 5 and 6 of that material.
Use phpMyAdmin (http://rosemary.mwc.edu/phpMyAdmin) and the appropriate SQL to
insert data into the tables so that if we try SELECT * FROM users we see the following
entries
and if we use SELECT * FROM shipinfo we have three records in the table as follows:
What do you see when you execute
SELECT * FROM users ORDER BY user_name ?
What do you see when you execute
SELECT name, email, zip FROM shipinfo ORDER BY zip
