+- 2DWorlds Forums (http://2dworlds.buildism.net/forum)
+-- Forum: Off Topic (http://2dworlds.buildism.net/forum/forumdisplay.php?fid=5)
+--- Forum: General Discussion (http://2dworlds.buildism.net/forum/forumdisplay.php?fid=17)
+--- Thread: My school suck at Tables. (/showthread.php?tid=8552)
My school suck at Tables. - Mustachio - 11-06-2011
![[Image: 6nulmw.png]](http://i42.tinypic.com/6nulmw.png)
I failed at the first question, but seriously!
RE: My school suck at Tables. - Jacob__mybb_import1 - 11-07-2011
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...
RE: My school suck at Tables. - Mustachio - 11-07-2011
(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).