A thief
-
I use this one a lot:
select * from tablename where 1 = 2
modified on Friday, February 20, 2009 12:53 PM
-
I use this one a lot:
select * from tablename where 1 = 2
modified on Friday, February 20, 2009 12:53 PM
-
:-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] -
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.
-
? 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
Sorry! corrected the query. I meant to say where 1 = 2 not 1 != 2.
-
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.
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.
-
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.
-
I use this one a lot:
select * from tablename where 1 = 2
modified on Friday, February 20, 2009 12:53 PM
Actually, I've gotten into the habit of adding a
where 1=1clause to all my queries. It makes it really easy to comment out different clauses for testing, because every line starts withand.select * from tablename where 1=1 and condition1 and condition2 and condition3In the above example, you can simply comment out (using--) any of thewhereclauses without worrying about trailing any leading or trailingand.The StartPage Randomizer - The Windows Cheerleader - Twitter
-
Actually, I've gotten into the habit of adding a
where 1=1clause to all my queries. It makes it really easy to comment out different clauses for testing, because every line starts withand.select * from tablename where 1=1 and condition1 and condition2 and condition3In the above example, you can simply comment out (using--) any of thewhereclauses without worrying about trailing any leading or trailingand.The StartPage Randomizer - The Windows Cheerleader - Twitter
Neat! I ought to remember this!
-
Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.
-
Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.