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.
1: | The integer 56678685 could be which data type(s)? |
A1: | MEDIUMINT, INT, or BIGINT. |
2: | 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') |
3: | 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 |
4: | How would you formulate a string comparison using LIKE to match first names of "John" or "Joseph"? |
A4: | LIKE 'Jo%' |
5: | 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. |
6: | 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.