> So I tried statements like these, and both work perfect! > update recorded set hostname = 'pc9h', starttime = starttime where hostname = 'pc4h'; > > update recorded set hostname = 'pc9h', starttime = starttime; Forgot this, this overrules the automatich update on starttime, so no new starttime is created and no dup keys are inserted. Bert.