> Hi. This is a really easy question:
>
> I have an existing table called clients. I have an existing field called
> CPicture. I'm trying to add a default value of "no".
>
> I've tried several times and can't seem to get it right. So, does anyone
> know how I can add a default value of "no" to an existing table (clients)
> and field (CPicture)?
>
> Thanks for your help.
> Mike
ALTER TABLE clients CHANGE CPicture VARCHAR(XXX) DEFAULT 'no';
(?)
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
