Add column if not exist

Add column if not exist

am 13.06.2006 03:05:57 von 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`;