A free-for-all thread

Put the world to rights here (off-topic discussion)
User avatar
Prometherion91
Denim Demon
Posts: 7754
Joined: Sun May 25, 2008 7:45 pm
Location: Leeds

Re: A free-for-all thread

Postby Prometherion91 » Fri Dec 02, 2011 3:52 pm

Womble wrote:Petri isn't fat. He's just ribbed for her pleasure.

User avatar
corrupt_toolbox
Denim Demon
Posts: 3572
Joined: Wed Apr 28, 2010 8:08 pm
Location: Bangor
Contact:

Re: A free-for-all thread

Postby corrupt_toolbox » Fri Dec 02, 2011 4:36 pm

Prometherion91 wrote:http://www.naturalnews.com/034289_Afghanistan_opium_trade.html

Lawdy.

Sources are Alex Jones and a random YouTube video?
:rofl:

User avatar
fitz
Knight of the Eemerald Svord
Posts: 649
Joined: Fri Aug 05, 2011 1:38 pm
Location: Abertawe
Contact:

Re: A free-for-all thread

Postby fitz » Fri Dec 02, 2011 5:29 pm

Hey I've started playing bass guitar again, I was wondering if there was a 'playing/tab thread' on the forum where musicians can discuss songs, techniques and stuff. I did a quick search but don't think I saw anything. I'm sure a lot of people on here play an instrument of some sort, was just wondering if anyone could point me to any good forums or good tab sites (preferably with a fair amount of metal tabs) to discuss and learn songs?
They say the pen is mightier than the sword... well, I say fuck the pen! Cause you're gonna die by the sword!

User avatar
Danroush
Denim Demon
Posts: 9436
Joined: Tue Aug 18, 2009 11:41 am
Location: Nottingham
Contact:

Re: A free-for-all thread

Postby Danroush » Fri Dec 02, 2011 5:29 pm

fitz wrote:Hey I've started playing bass guitar again, I was wondering if there was a 'playing/tab thread' on the forum where musicians can discuss songs, techniques and stuff. I did a quick search but don't think I saw anything. I'm sure a lot of people on here play an instrument of some sort, was just wondering if anyone could point me to any good forums or good tab sites (preferably with a fair amount of metal tabs) to discuss and learn songs?


http://www.ultimate-guitar.com/
Freyja wrote:I never used to be able to fit a whole one in my mouth. But now I can with ease.

TheLotusEater193 wrote:WHY IS IT SO TINY?!

TheLotusEater193 wrote:To be fair 1 and a half minutes is really good if you've never done it before.


http://www.facebook.com/Danroush1

User avatar
Jim
Denim Demon
Posts: 11935
Joined: Sun Dec 03, 2006 11:43 pm
Location: Alfreton, Derbyshire
Contact:

Re: A free-for-all thread

Postby Jim » Fri Dec 02, 2011 6:18 pm

corrupt_toolbox wrote:FAO Jim or anyone else who knows:

I'm struggling to put together some SQL statements I need since I haven't done it in a while. Specifically, in a university database, I'm asked to write a statement that returns a list of the modules (Module Id and Module Name) taught by a specified member of staff, say for this example Bob with the ID of '1'.
The relevant tables are:
Staff (staffId, staffName)
Module (moduleId, moduleName)
Teaches (staffId, moduleId)

There are three other questions too, but if I can understand this one I can probably do the others.
Cheers for any help.


Code: Select all

SELECT moduleId, ModuleName
FORM module m
INNER JOIN Teaches t on m.moduleID = t.moduleID
INNER JOIN Staff s on t.staffId = s.staffID
WHERE staffName = ?



This is T-SQL syntax and use of JOINs (and the parameter ?) but if you swap out the parameter it might just work in MySQL too.
Who the hell reads anything in sigs these days, unless it's an animated gif?

User avatar
jackcake
Denim Demon
Posts: 7487
Joined: Wed Mar 31, 2004 6:55 pm
Location: Moseley, Birmingham

Re: A free-for-all thread

Postby jackcake » Fri Dec 02, 2011 6:34 pm

http://www.bbc.co.uk/news/uk-england-bi ... m-16002765

One for lovers of those demon-worshipping balls of fur that lick their own arses and call it grooming, then eat with the same filthy mouth.
Sarchasm: The gulf between the author of sarcastic wit and the person who doesn't get it.

Last.fm

User avatar
peypea
Denim Demon
Posts: 7811
Joined: Fri Jun 04, 2010 4:41 pm
Contact:

Re: A free-for-all thread

Postby peypea » Fri Dec 02, 2011 6:47 pm

Seriously can't wait to go home for Christmas.
Image
Turbo wrote:One day I'll get around to tasting Pussy.

User avatar
keera_envenomed
Denim Demon
Posts: 7717
Joined: Mon Jun 04, 2007 7:54 pm
Location: Brizzle

Re: A free-for-all thread

Postby keera_envenomed » Fri Dec 02, 2011 6:49 pm

jackcake wrote:http://www.bbc.co.uk/news/uk-england-birmingham-16002765

One for lovers of those demon-worshipping balls of fur that lick their own arses and call it grooming, then eat with the same filthy mouth.


You're only jealous because no one would spend 6 grand on you if you fell out of a 4th storey window :P
2017 Gigs (here so I remember to go)

17/06 - Guns N' Roses - London
15/07 - Saor - London
10/08 - 13/08 - Bloodstock

JECP
Lowly Peon
Posts: 14
Joined: Sat Jan 15, 2011 10:41 am

Re: A free-for-all thread

Postby JECP » Fri Dec 02, 2011 7:18 pm

siliconfury wrote:
corrupt_toolbox wrote:FAO Jim or anyone else who knows:

I'm struggling to put together some SQL statements I need since I haven't done it in a while. Specifically, in a university database, I'm asked to write a statement that returns a list of the modules (Module Id and Module Name) taught by a specified member of staff, say for this example Bob with the ID of '1'.
The relevant tables are:
Staff (staffId, staffName)
Module (moduleId, moduleName)
Teaches (staffId, moduleId)

There are three other questions too, but if I can understand this one I can probably do the others.
Cheers for any help.


Code: Select all

SELECT moduleId, ModuleName
FORM module m
INNER JOIN Teaches t on m.moduleID = t.moduleID
INNER JOIN Staff s on t.staffId = s.staffID
WHERE staffName = ?



This is T-SQL syntax and use of JOINs (and the parameter ?) but if you swap out the parameter it might just work in MySQL too.


SELECT Module.moduleId, Module.moduleName
FROM Module, Teaches
WHERE Teaches.staffId = 1
AND Module.moduleId = Teaches.moduleId;

Something like that? If you need to search by staff name, you'll have to do something similar but include all 3 tables in the FROM clause. Haven't tested this; not sure if you always need to qualify the column names with the table name like I have, but you certainly do on the AND clause as it's a common column.

User avatar
Big D
Denim Demon
Posts: 9381
Joined: Thu Apr 01, 2004 7:51 pm
Location: Portsmouth

Re: A free-for-all thread

Postby Big D » Fri Dec 02, 2011 7:21 pm

I have a query.

Animal eyes reflect light. (dogs and cats anyway)

How come human eyes don't?

User avatar
Jim
Denim Demon
Posts: 11935
Joined: Sun Dec 03, 2006 11:43 pm
Location: Alfreton, Derbyshire
Contact:

Re: A free-for-all thread

Postby Jim » Fri Dec 02, 2011 7:24 pm

JECP wrote:
siliconfury wrote:
corrupt_toolbox wrote:FAO Jim or anyone else who knows:

I'm struggling to put together some SQL statements I need since I haven't done it in a while. Specifically, in a university database, I'm asked to write a statement that returns a list of the modules (Module Id and Module Name) taught by a specified member of staff, say for this example Bob with the ID of '1'.
The relevant tables are:
Staff (staffId, staffName)
Module (moduleId, moduleName)
Teaches (staffId, moduleId)

There are three other questions too, but if I can understand this one I can probably do the others.
Cheers for any help.


Code: Select all

SELECT moduleId, ModuleName
FORM module m
INNER JOIN Teaches t on m.moduleID = t.moduleID
INNER JOIN Staff s on t.staffId = s.staffID
WHERE staffName = ?



This is T-SQL syntax and use of JOINs (and the parameter ?) but if you swap out the parameter it might just work in MySQL too.


SELECT Module.moduleId, Module.moduleName
FROM Module, Teaches
WHERE Teaches.staffId = 1
AND Module.moduleId = Teaches.moduleId;

Something like that? If you need to search by staff name, you'll have to do something similar but include all 3 tables in the FROM clause. Haven't tested this; not sure if you always need to qualify the column names with the table name like I have, but you certainly do on the AND clause as it's a common column.


It's faster to use joins. Basically if you put multiple tables in the FROM clause, the database engine will typically do a cartesian product before filtering with WHERE. Use JOINs and it only matches up the rows in the FROM table first to the others, picks out what columns it needs, and finally filters by the WHERE.

Also in T-SQL you will need to fully qualify the table names in SELECT if there is ambiguity across tables.
Last edited by Jim on Fri Dec 02, 2011 7:27 pm, edited 3 times in total.
Who the hell reads anything in sigs these days, unless it's an animated gif?

User avatar
Jim
Denim Demon
Posts: 11935
Joined: Sun Dec 03, 2006 11:43 pm
Location: Alfreton, Derbyshire
Contact:

Re: A free-for-all thread

Postby Jim » Fri Dec 02, 2011 7:24 pm

Big D wrote:I have a query.

Animal eyes reflect light. (dogs and cats anyway)

How come human eyes don't?


Pupils aren't open wide enough relative to the size of the eyeball.
Who the hell reads anything in sigs these days, unless it's an animated gif?

JECP
Lowly Peon
Posts: 14
Joined: Sat Jan 15, 2011 10:41 am

Re: A free-for-all thread

Postby JECP » Fri Dec 02, 2011 7:37 pm

siliconfury wrote:
It's faster to use joins. Basically if you put multiple tables in the FROM clause, the database engine will typically do a cartesian product before filtering with WHERE. Use JOINs and it only matches up the rows in the FROM table first to the others, picks out what columns it needs, and finally filters by the WHERE.


Not according to this:

http://stackoverflow.com/questions/1216 ... n-vs-where

I always used the WHERE method at university and never lost any marks.

User avatar
Finnvitka
Denim Demon
Posts: 15479
Joined: Mon Jul 21, 2008 11:10 pm
Location: NCC-1701
Contact:

Re: A free-for-all thread

Postby Finnvitka » Fri Dec 02, 2011 7:47 pm

siliconfury wrote:
Big D wrote:I have a query.

Animal eyes reflect light. (dogs and cats anyway)

How come human eyes don't?


Pupils aren't open wide enough relative to the size of the eyeball.


would I be right in saying that red-eye in photos is the same effect?
tumblr|facebook
[Josh] i fucking love bottom ;_;

ImageImageImage

User avatar
Jim
Denim Demon
Posts: 11935
Joined: Sun Dec 03, 2006 11:43 pm
Location: Alfreton, Derbyshire
Contact:

Re: A free-for-all thread

Postby Jim » Fri Dec 02, 2011 7:49 pm

JECP wrote:
siliconfury wrote:
It's faster to use joins. Basically if you put multiple tables in the FROM clause, the database engine will typically do a cartesian product before filtering with WHERE. Use JOINs and it only matches up the rows in the FROM table first to the others, picks out what columns it needs, and finally filters by the WHERE.


Not according to this:

http://stackoverflow.com/questions/1216 ... n-vs-where

I always used the WHERE method at university and never lost any marks.
Hmm, strange, I always thought the SQL Server Query Profiler showed a massive cartesian half way through the query when using WHERE.

I've always used JOINs though in my 7 years of using Databases (mostly SQL Server since 2000 version), as they are far more readable and more controllable than joining with WHEREs.
Last edited by Jim on Fri Dec 02, 2011 7:55 pm, edited 3 times in total.
Who the hell reads anything in sigs these days, unless it's an animated gif?