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
  •