MYSQL - clear data every month?

Discussion in 'MySQL' started by twistedspikes, Mar 31, 2009.

  1. #1
    Is there any way to clear a set of rows in a certain table each month without having to go in and do it manually?

    Or would it be better to set up a script on my server to do something like this (PHP?)?

    Thanks,
    TS
     
    twistedspikes, Mar 31, 2009 IP
  2. wwwbryan

    wwwbryan Well-Known Member

    Messages:
    181
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    103
    #2
    I'm pretty sure its with PHP, unless you own the server and can configure it to do something.
     
    wwwbryan, Mar 31, 2009 IP
    twistedspikes likes this.
  3. twistedspikes

    twistedspikes Notable Member

    Messages:
    5,694
    Likes Received:
    293
    Best Answers:
    0
    Trophy Points:
    280
    #3
    Thanks,

    I'll have a look and see if I can find anything about it online. I don't own the server, its shared hosting.
     
    twistedspikes, Mar 31, 2009 IP
  4. OnInternetBusinessGuide

    OnInternetBusinessGuide Well-Known Member

    Messages:
    330
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    108
    #4
    A script is the way to go. To start your script at a precise time, you can sue the "Cron Jobs".
     
    twistedspikes likes this.
  5. kamalarora88

    kamalarora88 Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    hello sir
    kamal here
    ready to your work.
    kindly send me the whole information

    thanks
    kamal arora
     
    kamalarora88, Apr 2, 2009 IP