SET @table_schema = DATABASE(); SET @ddl = IF( EXISTS( SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = @table_schema AND TABLE_NAME = 'team_manager_base_info' AND COLUMN_NAME = 'can_change_country' ), 'SELECT 1', "ALTER TABLE `team_manager_base_info` ADD COLUMN `can_change_country` tinyint(1) NOT NULL DEFAULT 1 COMMENT '经理中心是否允许修改用户国家' AFTER `can_unban_user`" ); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt;