How to modify the record content and query of the record and return change records at the same time, it is actually a problem of two aspects, but not as a problem;

1. To modify a record, how to get the revised record values?
2. There is a table in one column is a timestamp, update automatically set value, currently using the two statements, now want to let the value of automatic updates, the query, or like 1, modified to return to the field values at the same time, how to do?