-- 客户端版本号改为 0.0.0 格式 ALTER TABLE `mes_client_upgrade` MODIFY COLUMN `version` varchar(32) NULL DEFAULT NULL COMMENT 'version'; UPDATE `mes_client_upgrade` SET `version` = CONCAT('0.0.', `version`) WHERE `version` IS NOT NULL AND `version` <> '' AND `version` NOT LIKE '%.%';