Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    15

    Unanswered: Deleting Record From Mysql

    im trying to automatically exprd the record on my databe... automaticlly delete on 7 days...


    what is the code for that?......

  2. #2
    Join Date
    Mar 2009
    Posts
    15
    How To Delete All Database Entires Older Than 8 Days?

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by erb
    How To Delete All Database Entires Older Than 8 Days?
    Code:
    DELETE
      FROM daTable
     WHERE daDate < CURRENT_DATE - INTERVAL 8 DAY
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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