Hello, I would like to do the following: I am creating a site where people can add items to a cart. In order to keep items for [X] amount of days, I would like to create a database table in mysql to hold a 'itemRef' and a 'Date'. Then in a relationship table I can hold the 'itemRef' and 'items' they have choosen. I think this would be simple.
But there are a lot of choices for the date field. I would like a date field that I can insert a now() or something, when I insert. And then later, through Java code, query and find all dates that are greater than [X] amount of days, and delete them to keep the database clean? So my question would be, A) which date type field should I create. B) how to insert now() C) can I run one query to find out if the date field is greater than [X] days? Any help would be appreciated. Sincerely Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
