From: Daevid Vincent
Date: May 24 2006 7:12pm
Subject: How do I add a column only if it doesn't exist?
List-Archive: http://lists.mysql.com/mysql/198265
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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


=D0=C65=CF=D0=20