Program: Build a DB using SSH ($$$)
Using putty for windows or terminal for mac, connect to the cbis3 server and create a grocery store database with the grocery_inventory table as shown on page 310.
add your username and a underscore to the name of your database such as:
tstudent_grocery_store
Run the SQL command to
add your username and a underscore to the name of your database such as:
tstudent_grocery_store
Run the SQL command to
- create the database
- create the table with the fields as shown in book or the video
- insert the 4 records shown on page 313 (note, do not insert the id, the auto_increment will do it for you)