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]
tt
- Original Message -
From: "Mike Mapsnac"
Sent: Saturday, January 03, 2004 5:37 PM
Subject: Alter table and setup Default value
> 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 defa
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')
