Re: Revert a column to its default value

2004-10-22 Thread Egor Egorov
Jonathan Kart <[EMAIL PROTECTED]> wrote: > > Hi all, > > > Is it possible in mysql 3.23 to update a row and revert a column back > to its default value. Not the default value for the type, but the > value defined as the column default. [] > UPDATE pictures SET picture_name=DEFAULT; <-- don'

Revert a column to its default value

2004-10-20 Thread Jonathan Kart
Hi all, Is it possible in mysql 3.23 to update a row and revert a column back to its default value. Not the default value for the type, but the value defined as the column default. for example a column is defined as : picture_name VARCHAR(25) NOT NULL DEFAULT 'no_photo.gif' if someone removes t