Re: Populate unique column with default value

On 10/1/07, Jon Horsman <horshaq@gmail.com> wrote:
> ... Is there an elegant way i can set the username
> to be the extension of the current row ...

UPDATE usertable
SET username = extension
WHERE username IS NULL;