SQL文件 变量设置

-- 定义一些变量
SET @ALWAYS = 1000;  -- Always, 100%
SET @VCOMMON = 240;  -- Very common, 24%
SET @COMMON = 150;   -- Common, 15%
SET @UNCOMMON = 100; -- Uncommon, 10%

-- 使用变量
INSERT INTO `XXDB` VALUES (3,0,0,1000,1916,@ALWAYS);
INSERT INTO `XXDB` VALUES (3,0,0,1000,1917,@VCOMMON);
INSERT INTO `XXDB` VALUES (3,0,0,1000,1918,@COMMON);
INSERT INTO `XXDB` VALUES (3,0,0,1000,1918,@UNCOMMON);