Re: get record last updated date

2003-03-31 Thread Matt Gostick
If you added a timestamp column when you created the table then it's easy... the timestamp column is updated automagically when an update or insert is done. create table tablename (id int, timestamp timestamp); select timestamp from tablename where id = 123; If you didn't use a timestamp column,

get record last updated date

2003-03-31 Thread Mike Doanh Tran
Hi, Is there a way in mysql to get the record's last updated date? Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]