I wrote: > Let's say I have a table with two columns, "id" which is unique and auto > incremented, and "time" which is int(10) unsigned (unix timestamp at time > record is added). Due to earlier problems with my insert statements, some > records do not have a time value (NULL). I want to provide an approximate > timestamp for those records without one, such as the timestamp from the last > record that has one. Is there a way to do this? Any help appreciated.
Nevermind, this worked: update tablename set time=if(isnull(time), @a, @a:=time); -Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]