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, then I don't know, and would be interested in the real answer. Matt. On Mon, 2003-03-31 at 13:21, Mike Doanh Tran wrote: > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]