How to clean up these forums with 3 MySQL commands

Collapse
Collapse
  • Time
  • Show
Clear All
new posts
  • mojack
    Sink the Pink
    Platinum Champion - 1,000-5,000 posts
    • Apr 2008
    • 2703
    • 135
    • 25
    • 9,042

    #1

    How to clean up these forums with 3 MySQL commands

    Here's a few MySQL commands for BigPoppa, hopefully should remove about 500 members on here so we can all get back to civilized boxing conversations.

    DELETE FROM members WHERE pac_fan = true
    AND status = "nuthugger"
    AND part-timer = true
    AND delusional = true;

    DELETE FROM members WHERE pavlik_fan = true
    AND mood = "sour g****s"
    AND excuses = true;

    DELETE FROM member WHERE hopkins_fan = true
    AND hopkins_bandwagon > 18-OCT-2008
    AND boxing_knowledge = null;


    If BigPoppa could run the queries asap, would much be appreciated.
  • miron_lang
    Banned
    Platinum Champion - 1,000-5,000 posts
    • Feb 2004
    • 4187
    • 1,389
    • 1,727
    • 18,862

    #2
    Delete from members
    where favorite_fighter = 'Pacquiao'

    go

    Comment

    • miron_lang
      Banned
      Platinum Champion - 1,000-5,000 posts
      • Feb 2004
      • 4187
      • 1,389
      • 1,727
      • 18,862

      #3
      Originally posted by mojack
      Here's a few MySQL commands for BigPoppa, hopefully should remove about 500 members on here so we can all get back to civilized boxing conversations.

      DELETE FROM members WHERE pac_fan = true
      AND status = "nuthugger"
      AND part-timer = true
      AND delusional = true;

      DELETE FROM members WHERE pavlik_fan = true
      AND mood = "sour g****s"
      AND excuses = true;

      DELETE FROM member WHERE hopkins_fan = true
      AND hopkins_bandwagon > 18-OCT-2008
      AND boxing_knowledge = null;


      If BigPoppa could run the queries asap, would much be appreciated.


      You dedicate 3 colums for 3 fighters. That means you have as many columns as there is fighters.


      Very BAD Data Architecture

      Comment

      • mojack
        Sink the Pink
        Platinum Champion - 1,000-5,000 posts
        • Apr 2008
        • 2703
        • 135
        • 25
        • 9,042

        #4
        You could insert a foreign key or even just reference via ID, but if I did that nobody would understand the MYSQL query as they wouldn't be able to see the 'boxers' table. :P

        Comment

        • miron_lang
          Banned
          Platinum Champion - 1,000-5,000 posts
          • Feb 2004
          • 4187
          • 1,389
          • 1,727
          • 18,862

          #5
          Originally posted by mojack
          You could insert a foreign key or even just reference via ID, but if I did that nobody would understand the MYSQL query as they wouldn't be able to see the 'boxers' table. :P
          I understand

          here's a more logical way of putting it. with the same readability for non SQL practioner.

          DELETE FROM members WHERE favorite_fighter = 'Pacquiao'
          AND fan_type = "nuthugger"
          AND member_type = 'part-timer'
          AND member_state = 'delusional' ;


          DELETE FROM members WHERE favorite_fighter = 'Pavlik'
          AND member_state = "sour g****s"
          AND member_mood = 'excuses' ;

          DELETE FROM member WHERE favorite_fighter = 'hopkins'
          AND favorite_fighter_last_modified >= 18-OCT-2008
          AND boxing_knowledge = null;
          Last edited by miron_lang; 10-21-2008, 04:17 AM.

          Comment

          • Flab
            Banned
            Unified Champion - 10,00-20,000 posts
            • Jan 2008
            • 11784
            • 883
            • 929
            • 19,525

            #6
            Did I just walk into a Star Wars convention?

            Comment

            • Castor_Troy
              Interim Champion
              Gold Champion - 500-1,000 posts
              • Feb 2007
              • 724
              • 244
              • 316
              • 7,564

              #7
              its I.T you JMM nut lover

              Comment

              • WhoreUs
                Banned
                Unified Champion - 10,00-20,000 posts
                • Oct 2008
                • 15770
                • 556
                • 606
                • 20,363

                #8
                Originally posted by ЯiZO
                Did I just walk into a Star Wars convention?
                nope.

                star trek.

                Comment

                • moochi
                  We need one organization!
                  Platinum Champion - 1,000-5,000 posts
                  • May 2004
                  • 3444
                  • 378
                  • 60
                  • 26,344

                  #9
                  MySQL....bring it on!!!!!!!

                  for a moment I thought I was in the wrong forum. Happy to see that there are some IT guys in here

                  Comment

                  • JoartCC
                    Banned
                    • Feb 2006
                    • 2439
                    • 157
                    • 0
                    • 3,087

                    #10
                    Originally posted by mojack
                    Here's a few MySQL commands for BigPoppa, hopefully should remove about 500 members on here so we can all get back to civilized boxing conversations.

                    DELETE FROM members WHERE pac_fan = true
                    AND status = "nuthugger"
                    AND part-timer = true
                    AND delusional = true;

                    DELETE FROM members WHERE pavlik_fan = true
                    AND mood = "sour g****s"
                    AND excuses = true;

                    DELETE FROM member WHERE hopkins_fan = true
                    AND hopkins_bandwagon > 18-OCT-2008
                    AND boxing_knowledge = null;


                    If BigPoppa could run the queries asap, would much be appreciated.
                    Let's use common sense.

                    Trying to filter a structure by using automated pre-made laws which will govern trains of thought which branches on multiple avenues...

                    Is just a waste of time.

                    The best method would be to let things be...

                    Set hard rules on racism...

                    And be *******.

                    The red line of course would be racism and that's all there is to it.

                    It's foolish to use a program which will lay down automated guidelines and empower the same program to act with punitive authority.

                    Might as well kick out mods and the site owner.

                    Comment

                    Working...
                    TOP