11-06-2011, 08:48 PM
I failed at the first question, but seriously!
My school suck at Tables.
|
11-06-2011, 08:48 PM
I failed at the first question, but seriously!
11-07-2011, 03:57 AM
(This post was last modified: 11-07-2011, 03:58 AM by Jacob__mybb_import1.)
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...
11-07-2011, 05:47 PM
(11-07-2011, 03:57 AM)Jacob_ Wrote: b. SELECT * FROM tbl_holidays WHERE `Num Nights` = '14' I forgot to mention, they set it out where the table = column(More BS from the school). |
« Next Oldest | Next Newest »
|