[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