Lesson 5 - Database

Question 1

ranged values

Answer 1

we can restrict our selections to a range e.g we can use WHERE stockitem = ‘shirt’ or > or < or <> (not equal to) or <= (less than or equal to) or >= (greater than or equal to)

Question 2

combinations (allows us to select multiple items)

Answer 2

e.g. Select fldstockitem, fldprice, fldcolour from TblInventory where
fldprice <= 45 and fldstockitem = ‘shirt’ and fldcolour = ‘blue’
(can use AND / OR)

Question 3

time and date ranges

Answer 3

• Mysql stores date in the format ‘YYYY-MM-DD ‘
• Mysql stores time in the format ‘hh:mm:ss’
  (needs the quotes)