MySQL社区

标题: 跪求：批量插入和更新资料 [打印本页]

作者: samliushui 时间: 2008-6-28 21:27
标题: 跪求：批量插入和更新资料
本人接触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 时间: 2008-6-28 22:48
就想知道怎么把下面的数据
"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 时间: 2008-6-30 14:36
参考一下帖子，构造一个：
http://www.mysqlpub.com/viewthread.php?tid=138&extra=page%3D2

作者: samliushui 时间: 2008-6-30 20:31
谢谢

作者: dearhwj 时间: 2008-7-2 19:24
提示: 作者被禁止或删除内容自动屏蔽

欢迎光临 MySQL社区 (http://mysqlpub.com/)