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.
  • 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