Gossamer Forum
Home : Products : Gossamer Links : Discussions :

New Column Suggestion

Quote Reply
New Column Suggestion
Already have a large populated DB and need to add new enum column "LinkType" and assign all as "CompInfo".

May I execute the statement on the command line (or SQL Monitor) or would this cause issues with LinksSQL?

Unless there is another way to populate an entire column (don't see any such option in PHPMyAdmin either).

Thanks

John
Quote Reply
Re: [gatman] New Column Suggestion In reply to
You should do this from the Links SQL table editor.

Database > Links/Properties.
Quote Reply
Re: [Paul] New Column Suggestion In reply to
So I have to manually check 1500 radio buttons?
Quote Reply
Re: [gatman] New Column Suggestion In reply to
No, when you add an enum column the default value will be inserted into all rows automatically.
Quote Reply
Re: [Paul] New Column Suggestion In reply to
Ok - understood