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't think

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