I added a column to my mysql table called
dateAdded which should hold a time value for each row. I want to add a time value into each row in the column, but I want it to count down by one day. I used:
UPDATE products set dateAdded=DATE_ADD('2015-06-15 11:31:31', INTERVAL 1 DAY)
but it just counts up one day and displays the exact same day for all the values in the column.
How can I add the date to the column and have it increment down by one day for each row?