-- 装箱单关联销售订单 ID。先执行结构升级,再部署后端;老数据按销售订单编号回填,匹配不到保持为空。 SET @package_sale_order_sql = IF( EXISTS (SELECT 1 FROM information_schema.columns WHERE table_schema=DATABASE() AND table_name='mes_wm_package' AND column_name='sale_order_id'), 'SELECT 1', 'ALTER TABLE mes_wm_package ADD COLUMN sale_order_id BIGINT NULL COMMENT ''销售订单ID,关联 erp_sale_order.id'' AFTER sales_order_code'); PREPARE package_sale_order_stmt FROM @package_sale_order_sql; EXECUTE package_sale_order_stmt; DEALLOCATE PREPARE package_sale_order_stmt; UPDATE mes_wm_package p JOIN erp_sale_order o ON o.no = p.sales_order_code COLLATE utf8mb4_unicode_ci AND o.deleted = 0 SET p.sale_order_id = o.id WHERE p.sale_order_id IS NULL AND p.sales_order_code IS NOT NULL;