469,923 Members | 1,745 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,923 developers. It's quick & easy.

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

Jun 13 '06 #1
0 4945

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by mr_burns | last post: by
6 posts views Thread by python1 | last post: by
reply views Thread by Michelle Stone | last post: by
5 posts views Thread by jib | last post: by
17 posts views Thread by Mike Fellows | last post: by
1 post views Thread by Sandro Daehler | last post: by
4 posts views Thread by Mike | last post: by
1 post views Thread by orenl | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.