Will this work in mysql?

[jeremyst]

Is it possible in mysql to do the following:

I have a table, and in it a column named Sent and a column named Date. What I need is a way for mysql to put the current date in the Date field when the Sent field for that row is updated. So if the Sent field went from 0, original state, to say 1, the current date would then be written in the Date column.

My application that I am running does not make the proper call to mysql to set the date, so I need a workaround so that I get the proper date when something is sent. No way to modify the Date call in the application. Already went that route.

Any help much appreciated.

Jake

[nnichols]

If you set your "Date" column to be a TIMESTAMP and it is the first or only TIMESTAMP field in the table, it will automatically be updated when you update any column.

Hope this helps 😉