Discover Habbo's history
Treat yourself with a Secret Santa gift.... of a random Wiki page for you to start exploring Habbo's history!
Happy holidays!
Celebrate with us at Habbox on the hotel, on our Forum and right here!
Join Habbox!
One of us! One of us! Click here to see the roles you could take as part of the Habbox community!


Page 1 of 2 12 LastLast
Results 1 to 10 of 18
  1. #1

    Default How do you automatically clear a table?

    How do you make a mysql database automaticly clear on a specific time at a spacific day?

    Such as Monday at 00:00.
    Thanks.

  2. #2
    Join Date
    May 2005
    Location
    San Francisco, CA
    Posts
    7,160
    Tokens
    2,331

    Latest Awards:

    Default

    Cron Jobs.

  3. #3
    Join Date
    Jul 2005
    Location
    -
    Posts
    2,995
    Tokens
    0

    Latest Awards:


  4. #4

    Default

    Quote Originally Posted by Invent View Post
    Cron Jobs.
    Humm, i must of typed that in a dif window.
    I know its done by cron jobs, but how do you do that =]

  5. #5
    Join Date
    Jul 2005
    Location
    -
    Posts
    2,995
    Tokens
    0

    Latest Awards:


  6. #6

    Default

    Quote Originally Posted by Jamie. View Post
    I was replying before you posted.

    Humm, Iv never got cron jobs. I gave in on them when they didnt work.
    What type of commands would clear a table in a database :s

  7. #7
    Join Date
    Apr 2006
    Location
    Leamington Spa
    Posts
    1,375
    Tokens
    72

    Latest Awards:

    Default

    MySQL:
    TRUNCATE TABLE `table_name` ;
    i've been here for over 8 years and i don't know why

  8. #8

    Default

    Quote Originally Posted by H! View Post
    MySQL:
    TRUNCATE TABLE `table_name` ;
    What do I do with that exactly?

  9. #9
    Join Date
    May 2005
    Location
    San Francisco, CA
    Posts
    7,160
    Tokens
    2,331

    Latest Awards:

    Default

    MySQL:
    TRUNCATE TABLE `table_name` ;
    'Cus that'll run automaticaly at 00:00 :rolleyes:

  10. #10

    Default

    Quote Originally Posted by Invent View Post
    'Cus that'll run automaticaly at 00:00 :rolleyes:
    Simon, you seam to be good with all this. Can you help me pls...

    Ill bribe you with money if you wish?

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •