creation date

Kim Kohen kim at webguide.com.au
Tue Apr 3 06:53:00 CDT 2007


g'day  Ruslan,

> alter_table_action
>    |    MODIFY [ COLUMN ] column_definition
••••
hmmm, above that it says:

	ALTER [ COLUMN ] column_name  < set default default_option | drop  
default>

I tried as suggested:

ALTER TABLE stories MODIFY COLUMN web_published DEFAULT 'false'

and it generated the error:

21:48:28: Error: line 1:1: unexpected token: DEFAULT

ALTER TABLE stories MODIFY COLUMN web_published set DEFAULT 'false'

gave this:

21:51:41: Error: line 1:1: unexpected token: set


cheers

kim




More information about the Valentina mailing list