On Fri, 23 Feb 2001 15:54:03 +0100, Yong Li <[EMAIL PROTECTED]>
wrote:

>>Hi,
>>
>>I wanted to create a column with type set, and to specify a default
>>value for this column, but I always got either SQL syntax error or
>>invalid default value error. What is the right syntax for doing this?
>>or, it's impossible to do this?
>>
>>I am using MySQL 3.23.25.
>>

col_name SET ("val1","val2") DEFAULT ""; # empty SET if not NULL

Cheers,


Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002















---------------------------------------------------------------------
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

Reply via email to