首页 › 1299程序专版「1299 files」 › 如何導入數據???

jiji0513 发表于 2008-11-2 20:59:58

如何導入數據???

以下是某位大大指點的寫法
以下經驗值增加與掉寶率
//經驗值

update k_monster set iexp = iexp*100

//掉寶率
update K_MONSTER_ITEM set sPersent01 = sPersent01*30
update K_MONSTER_ITEM set sPersent02 = sPersent01*30
update K_MONSTER_ITEM set sPersent03 = sPersent01*30
update K_MONSTER_ITEM set sPersent04 = sPersent01*30
update K_MONSTER_ITEM set sPersent05 = sPersent01*30

該如何導入到資料庫呢><"因為我是英文版又沒用過SQL2000 只用過MYSQL = =

麻煩哩~~

ctgwglzc 发表于 2008-11-2 21:11:55

搞个作业调度看看

p2306666 发表于 2008-11-2 21:32:37

不懂你的意思!!我知道如何導入了!
上網搜尋到此篇文章~
http://www.todayisp.com/support/FAQ/VHost/200808/18-358.html

導入卻出現錯誤><"如圖

麻煩高手是否可以協助看哪裡錯了或是有更法的方法可以設定經驗值倍率和掉寶率....



文件名: 42544.JPG
描述: 42544.JPG
下载地址: http://www.rayfile.com/files/b42c7697-a8e2-11dd-8349-0019d11a795f/
预览:
http://prefile8.rayfile.com/zh-cn/thumbnail/d41d8cd98f00b204e9800998ecf8427e/thumbnail.jpg

binwang 发表于 2008-11-2 22:56:40

查询分析器，输入，F5

jiji0513 发表于 2008-11-3 13:40:33

了解了感恩^^"

[ 本帖最后由 jiji0513 于 2008-11-3 13:50 编辑 ]

jiji0513 发表于 2008-11-3 16:40:40

update k_monster set iexp = iexp*100;
update K_MONSTER_ITEM set sPersent01 = sPersent01*30
update K_MONSTER_ITEM set sPersent02 = sPersent02*30
update K_MONSTER_ITEM set sPersent03 = sPersent03*30
update K_MONSTER_ITEM set sPersent04 = sPersent04*30
update K_MONSTER_ITEM set sPersent05 = sPersent05*30
我導入以上出現以下訊息
Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type int.
The statement has been terminated.
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 153000.
The statement has been terminated.
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 300000.
The statement has been terminated.
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 36000.
The statement has been terminated.
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 90000.
The statement has been terminated.
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 60000.
The statement has been terminated.


哪裡有錯誤嗎???

demon2k 发表于 2008-11-3 16:44:59

是不是你制定的表不对？

demon2k 发表于 2008-11-3 16:46:35

这些语句是指向 k_monster 表的 iexp 项，表不对或者没有这项都可能出错

jiji0513 发表于 2008-11-3 17:12:01

確定有此表格說><"這次我改成


update K_MONSTER set iexp = iExp*10;
update K_MONSTER_ITEM set sPersent01 = sPersent01*10,sPersent02*10,sPersent03*10,sPersent04*10,sPersent05*10
update K_MONSTER_ITEM$ set sPersent01 =
sPersent01*10,sPersent02*10,sPersent03*10,sPersent04*10,sPersent05*10

出現
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '*'.
10,sPersent05*10

jiji0513 发表于 2008-11-3 17:31:43

經驗值成功~~有變...掉寶率則不變的感覺 = =" 打怪錢都是掉那麼少 = =

查看完整版本: 如何導入數據???