Google
发新话题
打印

[已解决] sql语句执行无效果

本主题由 wayl 于 2008-4-5 16:35 分类

sql语句执行无效果

-- T1需要1G,0级
-- 奥术师
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '201';
-- 预言
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '202';
-- 恶魔之心
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '203';
-- 夜幕杀手
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '204';
-- 塞纳里奥
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '205';
-- 巨兽之王
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '206';
-- 大地之怒
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '207';
-- 秩序之源
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '208';
-- 力量
UPDATE `items` SET `buyprice` = '10000',`requiredlevel` = '0',`sellprice` = buyprice*0.1 WHERE `itemset` = '209';

-- T2需要20G,30级
-- 灵风
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '210';
-- 卓越
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '211';
-- 复仇
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '212';
-- 血牙
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '213';
-- 怒风
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '214';
-- 驭龙者
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '215';
-- 无尽风暴
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '216';
-- 审判
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '217';
-- 愤怒
UPDATE `items` SET `buyprice` = '200000',`requiredlevel` = '30',`sellprice` = buyprice*0.1 WHERE `itemset` = '218';

-- T3需要50G,60级
-- 梦游者
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '521';
-- 无畏
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '523';
-- 古镰
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '524';
-- 信仰
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '525';
-- 霜火
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '526';
-- 碎地者
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '527';
-- 救赎
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '528';
-- 瘟疫之心
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '529';
-- 地穴追随者
UPDATE `items` SET `buyprice` = '500000',`requiredlevel` = '60',`sellprice` = buyprice*0.1 WHERE `itemset` = '530';




---------------------------------------------------------------------------


这段修改套装价格和等级的语句..执行后没有效果啊


打开数据库后..按F6执行语句...显示这样..


[ 本帖最后由 ycfengling 于 2008-4-5 09:24 编辑 ]
附件: 您所在的用户组无法下载或查看附件

TOP

请求解决.....等一晚上了

TOP

语句错误``
把所有的' 去掉。后面的2个;; 留一个。
顺便把 -- 地穴追随者(注视)一起删掉。

TOP

问题已解决...
感谢ylie....

TOP

发新话题