SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; ALTER TABLE `t_statement_calculation` DROP COLUMN IF EXISTS `year`, DROP COLUMN IF EXISTS `month`, MODIFY COLUMN IF EXISTS `day` int(11) NULL DEFAULT NULL AFTER `calculation_collection_id`; SET FOREIGN_KEY_CHECKS = 1;