跪求：批量插入和更新资料

samliushui

本人接触SQL 不久，最近遇到几个问题。
我要批量改网站价格 用EDITPLUS 编辑。
从数据库里把PRICE 和GOOD_sn导了出来，下图；（不能插图）
"13.99","ces63"
"4.79","ces61"
"5.19","ces60"
"12.99","ces59"
"5.19","ces58"
"1.49","ces57"
"0.99","ces55"
"1.49","ces56"
"0.99","ces54"
"0.99","ces53"
"6.66","ces52"
"8.59","ces51"
前面数字是价格，后面是对应的产品编码。
我看网上说可以用EDITPLUS 编辑成 insert into table1 values。。。 用替换的方式变成单一个个语句更新。
请问有人能详细指点一下吗。
不胜感激！

samliushui

就想知道 怎么把下面的数据
"13.99","ces63"
"4.79","ces61"
"5.19","ces60"
"12.99","ces59"
"5.19","ces58"
"1.49","ces57"
"0.99","ces55"
"1.49","ces56"
"0.99","ces54"
"0.99","ces53"
"6.66","ces52"
"8.59","ces51"
批量换成
insert into DES_goods (price, sn) values("17.99", "CES63");
。。。。

kider

参考一下帖子，构造一个：
http://www.mysqlpub.com/viewthread.php?tid=138&extra=page%3D2

samliushui

谢谢

dearhwj

如果是mysql 是否能够用 LOAD DATA 搞定
http://dev.mysql.com/doc/refman/5.0/en/load-data.html