mysql expire after?

Out of context: Reply #6

• Started
• Last post
• 6 Responses

• nospacebar0

  An alternative to this would be to add the time of insertion, and when selecting those rows, have a time limit for what it returns.

  For 30 days:
  SELECT * FROM table WHERE WHERE date_column > DATE_SUB(CURDATE(),INTERVAL 30 DAY);

  More here:http://dev.mysql.com/doc/re...

  nospacebar 0Permalink

  UpvoteDownvote

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel

View thread