The end of WW2 with SQL

[Jonny69]

SQL statements just received from US office. 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 TABLENAME='STATUS'

Ithankyouverymuch. I am bored at work.

 

[Jonny69]

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?

 

[Jonny69]

going by the lack of "IF" used when warned about Pearl harbour, I would say you did the right thing leaving it out

Ah but I am system admin, I have access to run update statements on the SQL Update table. I'll just put a sly INSERT INTO statement in and no-one will ever know the Americans didn't check.

 

[Jonny69]

I just tried to Citrix into the database in Iraq but I got some weird message back. I think they must use Oracle in the middle east.

 

[Jonny69]

Maybe its a really bad Db design and he has tables named after the worlds major cities?

It's just something that goes back to when it was a DOS-based database and nobody has ever got round to changing. It'll be addressed by version 5 they assure us