Re: Update field base on value from another row

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

Update field base on value from another row

Hi there, 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