Hi Mike,
It's just part of modifying the column to change the DEFAULT value.
e.g. you might use this (changes to NOT NULL and DEFAULT value of
'new'):
ALTER TABLE table MODIFY type ENUM('new','used') NOT NULL DEFAULT 'new';
Hope that helps.
Matt
----- 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 default
value
> NULL, but I want to setup default value used. How that's can be done?
>
> type | enum('new',used') | YES | | NULL | |
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
