PDA

View Full Version : The end of the war in SQL


Jonny69
05-09-2007, 11:08
SQL statements just received from US. Please run on JAPAN database:

DELETE FROM HIROSHIMA WHERE DATE='06/08/1945'
DELETE FROM NAGASAKI WHERE DATE='09/08/1945'

When complete please run this:

UPDATE JAPAN SET SURRENDER='Y', FLAG=WHITE WHERE TABLEMNAME='STATUS'

Ithankyouverymuch. I am bored at work.

Jasper
05-09-2007, 11:21
DELETE FROM jasper.memories WHERE boat_drinks_post_id = 144599

:p

Feek
05-09-2007, 11:23
/me giggles in a geeky way

Jonny69
05-09-2007, 11:30
I should have put an IF statement before the DELETE FROM NAGASAKI WHERE DATE='09/08/1945' to check for surrender status. I must address my history knowledge. But would the Americans have really checked?

Davey_Pitch
05-09-2007, 11:37
I found it amusing :D

Jonny69
05-09-2007, 11:44
Have been frantically trying to update the earlier helpdesk case notes. With all this action I've got very behind...

Last Update By:
Adolf Hitler

Case Description:
Approval problems invading Poland

Last case notes update:
Updated field on WW2LEDG, warned client of imminent invasion from countryid GERMANY.

Gaijin
05-09-2007, 22:04
SELECT WEAPONRY FROM FEEKSCABINET WHERE 'PAINPOTENTIAL' > 5000000
SET 'CALIBRE'=50CAL
ORDER BY LETHALITY
GROUPBY COLOUR
DROP TABLE JOHNNY69;






Syntax is probably out but uni knowledge is but a faint memory now ;)