Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. A thief

A thief

Scheduled Pinned Locked Moved The Lounge
database
24 Posts 17 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Lost User

    select * from tablename where(1<2); Works on any database

    R Offline
    R Offline
    Rama Krishna Vavilala
    wrote on last edited by
    #8

    I use this one a lot:

    select * from tablename where 1 = 2

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

    M M M 3 Replies Last reply
    0
    • C 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]

      realJSOPR Offline
      realJSOPR Offline
      realJSOP
      wrote on last edited by
      #9

      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

      1 Reply Last reply
      0
      • realJSOPR 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

        P Offline
        P Offline
        Paul Conrad
        wrote on last edited by
        #10

        :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

        1 Reply Last reply
        0
        • L Lost User

          select * from tablename where(1<2); Works on any database

          F Offline
          F Offline
          fred_
          wrote on last edited by
          #11

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

          1 Reply Last reply
          0
          • C 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]

            C Offline
            C Offline
            CPallini
            wrote on last edited by
            #12

            :-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]

            L 1 Reply Last reply
            0
            • R Rama Krishna Vavilala

              I use this one a lot:

              select * from tablename where 1 = 2

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

              M Offline
              M Offline
              MrEyes
              wrote on last edited by
              #13

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

              1 Reply Last reply
              0
              • R Rama Krishna Vavilala

                I use this one a lot:

                select * from tablename where 1 = 2

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

                M Offline
                M Offline
                Member 96
                wrote on last edited by
                #14

                ? 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

                R 1 Reply Last reply
                0
                • C 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]

                  L Offline
                  L Offline
                  led mike
                  wrote on last edited by
                  #15

                  CPallini wrote:

                  My 5.

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

                  P 1 Reply Last reply
                  0
                  • L Lost User

                    select * from tablename where(1<2); Works on any database

                    S Offline
                    S Offline
                    Single Step Debugger
                    wrote on last edited by
                    #16

                    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.

                    S 1 Reply Last reply
                    0
                    • M 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

                      R Offline
                      R Offline
                      Rama Krishna Vavilala
                      wrote on last edited by
                      #17

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

                      1 Reply Last reply
                      0
                      • S 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.

                        S Offline
                        S Offline
                        Single Step Debugger
                        wrote on last edited by
                        #18

                        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.

                        L 1 Reply Last reply
                        0
                        • S 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.

                          L Offline
                          L Offline
                          Lost User
                          wrote on last edited by
                          #19

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

                          I are troll :)

                          1 Reply Last reply
                          0
                          • R Rama Krishna Vavilala

                            I use this one a lot:

                            select * from tablename where 1 = 2

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

                            M Offline
                            M Offline
                            Miszou
                            wrote on last edited by
                            #20

                            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

                            R 1 Reply Last reply
                            0
                            • M 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

                              R Offline
                              R Offline
                              Rama Krishna Vavilala
                              wrote on last edited by
                              #21

                              Neat! I ought to remember this!

                              1 Reply Last reply
                              0
                              • L led mike

                                CPallini wrote:

                                My 5.

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

                                P Offline
                                P Offline
                                PIEBALDconsult
                                wrote on last edited by
                                #22

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

                                L 1 Reply Last reply
                                0
                                • P PIEBALDconsult

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

                                  L Offline
                                  L Offline
                                  led mike
                                  wrote on last edited by
                                  #23

                                  PIEBALDconsult wrote:

                                  a few months ago

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

                                  1 Reply Last reply
                                  0
                                  • L Lost User

                                    select * from tablename where(1<2); Works on any database

                                    Z Offline
                                    Z Offline
                                    Zhat
                                    wrote on last edited by
                                    #24

                                    how about: Delete DumbAss from CP_List_Of_Jerks where DumbAss = 'onyang2' Better yet: Delete * from Life where DumbAss = 'onyang2'

                                    1 Reply Last reply
                                    0
                                    Reply
                                    • Reply as topic
                                    Log in to reply
                                    • Oldest to Newest
                                    • Newest to Oldest
                                    • Most Votes


                                    • Login

                                    • Don't have an account? Register

                                    • Login or register to search.
                                    • First post
                                      Last post
                                    0
                                    • Categories
                                    • Recent
                                    • Tags
                                    • Popular
                                    • World
                                    • Users
                                    • Groups