malys
4/23/2014 - 9:31 AM

Drop Columns if exist

Drop Columns if exist

dropColumn.sql
content_copyfile_download


IF EXISTS ( SELECT * FROM information_schema.columns WHERE table_name = 'country' AND column_name = 'created_at' AND table_schema = DATABASE() ) THEN
    ALTER TABLE `country` DROP COLUMN `created_at`;
END IF;

Because DROP COLUMN IF EXISTS isn't supported by MySQL.