Re: Alter table and setup Default value

[robert_rowe]

This worked for me:

ALTER TABLE `test` CHANGE `somefield` `somefield` enum('new','used') DEFAULT 'new' 

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