Demonstrate the following queries:
Select all columns from a table use LIMIT 20 if you dont want to get too long a results list
Select several, but not all columns from a table use LIMIT if you wish
Select several columns using a WHERE clause to filter out specific data from one of those columns
Select several columns using a WHERE clause on a columns NOT in the select column list
Select using a where clause that specifies a range for a specific column ,.. this should use and AND or OR in the WHERE clause
Select using a where clause that uses a subselect from another table to filter the result this should use an IN clause use the diagram to find tables with common keys
SELECT data from 2 or more tables using a JOIN
SELECT data from 2 or more tables using a JOIN and DISTINCT clauses
SUBMIT:
Queries
Query results
Explanation of the query and results
Any additional observations did anything unexpected happen? could you not do something the way you might have wanted? etc.
Demonstrate the following queries:
INSERT a single row into a table
INSERT multiple rows into a table using a single query
CREATE a new table that is structurally identical to another table Ill call this NewTable2 in the following instructions
INSERT multiple rows into NewTable2 make sure that some of those rows have duplicate keys as rows in the original table
INSERT all the rows from NewTable2 into the original table does this work? were any rows inserted?
INSERT all rows from NewTable2 into the original table where keys are not duplicated
INSERT all rows from NewTable2 into the original table if keys are duplicated, the data from NewTable2 should update the original table rows show that this worked
SUBMIT:
Queries
Query results
Explanation of the query and results
Any additional observations did anything unexpected happen? could you not do something the way you might have wanted? etc.