The Workshop is designed to help you anticipate possible questions, review what you've learned, and begin learning how to put your knowledge into practice.
The integer 56678685 could be which data type(s)?
| A1: |
MEDIUMINT, INT, or BIGINT.
How would you define a field that could only contain the following strings: apple, pear, banana, cherry?
| A2: |
ENUM ('apple', 'pear', 'banana', 'cherry') or SET ('apple', 'pear', 'banana', 'cherry')
What would be the LIMIT clauses for selecting the first 25 records of a table? Then the next 25?
| A3: |
LIMIT 0, 25 and LIMIT 26, 25
How would you formulate a string comparison using LIKE to match first names of "John" or "Joseph"?
| A4: |
How would you explicitly refer to a field called id in a table called table1?
| A5: |
Use table1.id instead of id in your query.
Write an SQL statement that joins two tables, orders, and items_ordered, with a primary key in each of order_id. From the orders table, select the following fields: order_name and order_date. From the items_ordered table, select the item_description field.
| A6: |
SELECT orders.order_name, orders.order_date, items_ordered.item_description FROM orders LEFT JOIN items_ordered ON orders.order_id = items_ordered.id.
Take the time to create some sample tables, and practice using basic INSERT and SELECT commands.