Comments on: Totally Geek Database Humour

By: Ling

Ling — Fri, 12 Oct 2007 20:19:07 +0000

can’t believe some database geek would intentiionally create trouble for his son…lol..

By: Tim

Tim — Thu, 11 Oct 2007 00:22:36 +0000

???

I have no idea… yeechh…

By: CC

CC — Wed, 10 Oct 2007 23:48:29 +0000

Definitely a contest! First off what this does. Imagine a student database system and your inserting student records:

> insert into students (id, name) values (1,’C Clarke’),(2,’B Clarke’),(3,’G Clarke’);
OK 3 records inserted

> insert into students (id,name) values(4,’L Lu’),(4, ‘Robert’); DROP TABLE Students;’),(5,’T Lu’);
OK 2 records inserted
OK Table Students dropped
SYNTAX ERROR statement: ‘),(5,’T Lu’)
> select * from students;
ERROR Table students doesn’t exist

As for the last statement — always make sure your data has been processed so it can’t turn into a statement!

By: bob

bob — Wed, 10 Oct 2007 23:33:04 +0000

I think I get some of it. Not good, I bet. I get lost in the last line. Does that make me less of a geek? Is this a competition?