Add column if not exist

[Jared]

Hi,

In pure sql script I would like to handle possible error 1060.

ALTER TABLE `MyTable`.`flat-rooms` ADD COLUMN `guestsin` VARCHAR(1) NOT
NULL DEFAULT 'N' AFTER `keysin`;