Enter DBMS Commands: CREATE TABLE Test ( things VARCHAR(20) , numbers INTEGER ) PRIMARY KEY ( things , numbers ) ; Enter DBMS Commands: INSERT INTO Test VALUES FROM ( "One" , 1 ) ; Enter DBMS Commands: INSERT INTO Test VALUES FROM ( "Two" , 2 ) ; Enter DBMS Commands: INSERT INTO Test VALUES FROM ( "Three" , 3 ) ; Enter DBMS Commands: INSERT INTO Test VALUES FROM ( "Four" , 4 ) ; Enter DBMS Commands: SHOW Test ; Passing the following arguments to dbEngine: Command: SHOW -------------------------- Test ------------- things VARCHAR(20) One Two Three Four ------------- ------------- numbers INTEGER 1 2 3 4 ------------- -------------------------- Enter DBMS Commands: Test2 <- select ( things == "One" ) Test ; Passing the following arguments to dbEngine: Command: SHOW -------------------------- Test2 ------------- things VARCHAR(20) One ------------- ------------- numbers INTEGER 1 ------------- -------------------------- Enter DBMS Commands: SHOW testing ; -------------------------- testing ------------- name VARCHAR(20) one two three 1 2 3 ------------- -------------------------- Enter DBMS Commands: SHOW test1 ; -------------------------- test1 ------------- name VARCHAR(20) one two three ------------- -------------------------- Enter DBMS Commands: SHOW testing - test1 ; -------------------------- TEMP ------------- name VARCHAR(20) 1 2 3 ------------- -------------------------- Enter DBMS Commands: SHOW Food ; -------------------------- Food ------------- Breakfast VARCHAR(20) Pancakes Waffles Biscuits ------------- ------------- Lunch VARCHAR(20) Turkey Sandwich Caesar Salad Pizza ------------- ------------- Dinner VARCHAR(20) Steak Shrimp Ribs ------------- -------------------------- Enter DBMS Commands: SHOW select ( Lunch == "Pizza" || Dinner == "Steak" ) Food ; -------------------------- TEMP ------------- Breakfast VARCHAR(20) Biscuits Pancakes ------------- ------------- Lunch VARCHAR(20) Pizza Turkey Sandwich ------------- ------------- Dinner VARCHAR(20) Ribs Steak ------------- -------------------------- Enter DBMS Commands: SHOW project ( Dinner ) Food ; Passing the following arguments to dbEngine: Command: SHOW -------------------------- Food Projection ------------- Dinner VARCHAR(20) Steak Shrimp Ribs ------------- -------------------------- Enter DBMS Commands: UPDATE Food SET ( Dinner = \"SUCCESS\" ) WHERE ( Breakfast == \"Pancakes\" ) ; -------------------------- Food ------------- Breakfast VARCHAR(20) Pancakes Waffles Biscuits Pancakes ------------- ------------- Lunch VARCHAR(20) Turkey Sandwich Caesar Salad Pizza Sushi ------------- ------------- Dinner VARCHAR(20) SUCCESS Shrimp Ribs Lasagna ------------- -------------------------- Enter DBMS Commands: DELETE FROM Food WHERE ( Dinner == "Ribs" ) ; Enter DBMS Commands: SHOW Food ; Passing the following arguments to dbEngine: Command: SHOW -------------------------- Food ------------- Breakfast VARCHAR(20) Pancakes Waffles Pancakes ------------- ------------- Lunch VARCHAR(20) Turkey Sandwich Caesar Salad Sushi ------------- ------------- Dinner VARCHAR(20) SUCCESS Shrimp Lasagna ------------- --------------------------