A thief

[realJSOP]

He's on yang2. It must be some sort of new oriental mind expanding drug...

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

[Chris Meech]

:wtf: :wtf: :wtf: It didn't work on mine :confused: :confused: :confused:

select * from tablename where (1<2)
*
ERROR at line 1:
ORA-00942: table or view does not exist

:)

Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

[Graham Bradshaw]

Chris Meech wrote:

It didn't work on mine

I'm not surprised. The OP's SQL was written on a blue background - yours is on a yellow background.

[Lost User]

All you need now is access to a database... which you should never, ever be given. Use your specially crafted h4ck3r skills to root some boxes, yo!

Check out the CodeProject forum Guidelines[^]

[Rama Krishna Vavilala]

I use this one a lot:

select * from tablename where 1 = 2

modified on Friday, February 20, 2009 12:53 PM

[realJSOP]

even though both of you spelled "*" correctly...

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

[Paul Conrad]

:laugh:

"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

[fred_]

OK either I'm really old or tired. I Don't get this

[CPallini]

:-D My 5.

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]

[MrEyes]

I prefer this one myself: select top 42 * from tablename where('the meaning of life' != 'answered');

[Member 96]

? Were you making a subtle joke that I missed? How is that different than select * from tablename?

---

"It's so simple to be wise. Just think of something stupid to say and then don't say it." -Sam Levenson

[led mike]

CPallini wrote:

My 5.

What about your 5? Are you trying to hijack this thread?

[Single Step Debugger]

Hey, onyang2 try this: delete from tablename where(1 < 2). Cool isn’t it?

The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.

[Rama Krishna Vavilala]

Sorry! corrected the query. I meant to say where 1 = 2 not 1 != 2.

[Single Step Debugger]

I was one-voted. Obviously some idiot executed the statement upon his database.

The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.

[Lost User]

That must be the first one-vote that actually carries satisfaction - it made my day :cool:

I are troll :)

[Miszou]

Actually, I've gotten into the habit of adding a where 1=1 clause to all my queries. It makes it really easy to comment out different clauses for testing, because every line starts with and. select * from tablename where 1=1   and condition1   and condition2   and condition3 In the above example, you can simply comment out (using --) any of the where clauses without worrying about trailing any leading or trailing and.

The StartPage Randomizer - The Windows Cheerleader - Twitter

[Rama Krishna Vavilala]

Neat! I ought to remember this!

[PIEBALDconsult]

Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.

[led mike]

PIEBALDconsult wrote:

a few months ago

I was just inducted today[^], that's why I made that comment ;)