From: Daevid Vincent
Date: September 21 2003 7:55pm
Subject: How to update/set a default value for field via delete statement
List-Archive: http://lists.mysql.com/mysql/150227
Message-Id: <001001c3807a$55cc1770$8d0aa8c0@gabriel>
MIME-Version: 1.0
Content-Type: text/plain;	charset="us-ascii"
Content-Transfer-Encoding: 7bit

I have my schema set so that a field in a table has a default value of 16.

I also have a script that "initializes" the database, but I don't want to
delete the record since I want the other fields' data preserved. Is there a
way to find out what the default schema value is so that I can issue an
UPDATE and set it back?

Daevid Vincent
http://daevid.com