I have a table with two timestamp(14) fields called add_date and updated. When I insert a new entry I want the current date/time set into these two fields. When I update the entry I only want the updated field to change. The problem is that everytime I update the entry, both fields' timestamps are changed.

When I do an UPDATE query, I set updated = now()

My settings for both fields are timestamp(14) and fields can be NULL.

Any ideals on what I'm doing wrong?