[KLUG Members] MySQL weirdness ...

Bert Bbbink kalamazoo at dse.nl
Wed Oct 12 04:14:35 EDT 2005



> 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.


More information about the Members mailing list