Hi scott,
you can use datetime or timestamp. Using timestamp in this example shows you
that now() can be a default or inserted value. You can also use
current_tiumestamp.
Other functions like date_add can help you to look for rows verifying interval
days like in this example :
mysql> create table
Hi Scott,
I show you timestamp usage, but there is also datetime and date. you can read
detailled infos at :
http://dev.mysql.com/doc/mysql/en/datetime.html
mysql> create table items(itemRef varchar(10), dat timestamp default
current_timestamp);
Query OK, 0 rows affected (0.20 sec)
mysql>
mysql>
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'
