List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:May 24 2006 7:12pm
Subject:How do I add a column only if it doesn't exist?
View as plain text  
I want to do something like this:

if not exists `hotel_page_templates`.`hpt_custom_fields`
alter table `hotel_page_templates` add column `hpt_custom_fields` text after
`hpt_alternate_username`;


ÐÆ5ÏÐ 

Thread
How do I add a column only if it doesn't exist?Daevid Vincent24 May
Re: How do I add a column only if it doesn't exist?sheeri kritzer25 May