My school suck at Tables.
#1
[Image: 6nulmw.png]

I failed at the first question, but seriously!
Reply
#2
b. SELECT * FROM tbl_holidays WHERE `Num Nights` = '14'
c. SELECT * FROM tbl_holidays WHERE Cost < '200'
d. SELECT * FROM tbl_holidays WHERE destination != 'France'

The second fixes in b and c might not be needed depending on which database you're using, but you definitely put in the wrong table name.

Having spaces in column names is horrible database design though...
Reply
#3
(11-07-2011, 03:57 AM)Jacob_ Wrote: b. SELECT * FROM tbl_holidays WHERE `Num Nights` = '14'
c. SELECT * FROM tbl_holidays WHERE Cost < '200'
d. SELECT * FROM tbl_holidays WHERE destination != 'France'

The second fixes in b and c might not be needed depending on which database you're using, but you definitely put in the wrong table name.

Having spaces in column names is horrible database design though...

I forgot to mention, they set it out where the table = column(More BS from the school).
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)