[mythtv] RFC: Program table change timestamp

George Nassas gnassas at mac.com
Sun Apr 19 04:00:01 UTC 2009


On 18-Apr-09, at 11:25 PM, Chase Douglas wrote:

> This gives me a table-wide update time, but I need an update time  
> for each row.


create table stamps (n int, o int,
     t timestamp default current_timestamp on update current_timestamp);
insert into stamps (n) values (1), (2);
select * from stamps;

-- wait a second or two --

update stamps set o = 1 where n = 2;
select * from stamps;

For me row 1 keeps the original time while row 2 shows an update. What  
do you see?

- George


More information about the mythtv-dev mailing list