Add column if not exist

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