打印

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

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

pengge911

瓜哥

排长

Rank: 2 Rank: 2

UID: 5162
帖子: 119
精华: 0
银子: 1065 两
小鲸鱼: 0 条
在线时间: 50 小时
注册时间: 2008-3-20
最后登录: 2008-6-5

夜猫勋章

发短消息
加为好友
当前离线

楼主大中小发表于 2008-4-5 03:14 只看该作者

sql语句执行无效果

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

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

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

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

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

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

[ 本帖最后由 ycfengling 于 2008-4-5 09:24 编辑 ]