Alter table and setup Default value

[Mike Mapsnac]

I use MYSQL 4. I can  modify or alter a column with no problems. But how I 
can alter table and setup Default value. The column below has default value 
NULL, but I want to setup default value used. How that's can be done?

type  | enum('new',used') | YES  |     | NULL    |                |

_________________________________________________________________
Have fun customizing MSN Messenger — learn how here!  
http://www.msnmessenger-download.com/tracking/reach_customize

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]