Max
3/21/2005 10:50:00 AM
O IAIN ?I?OIO EIOAOAOIAA
IOOII ?OIA?AAEOEOO OAAIEAO main
A EIAIII ?IIN pricesale E qty.
AAIIUA AAOOOON EU OAAIEAU tmp
OOII?EA ?I EIOIOIIO ?OIEOEIAEO A?AAEO main.barcode=tmp.barcode
AIN MS SqlServer IOIE?II ?OIEIAEI UA?OIO
update main
set main.pricesale=tmp.pricesale
set main.qty=tmp.qty
from main
left join tmp on main.barcode=tmp.barcode
where main.barcode=tmp.barcode
OIEA AIN mysql OAEIE UA?OIO IA ?IAEIAEO ?I OEIOAEOEOO
A ?IO UOIO UA?OIO ?OIEIAEO ?I OEIOAEOEOO
update main
set main.pricesale=tmp.pricesale,main.qty=tmp.qty
from main,tmp
where main.barcode=tmp.barcode
AOOO OIIOEI IAII IAIAIOEIA ii, UOIO UA?OIO ?IIIIOOO COOUEO ?OIA ?IA OAIOA
UA?NUEO(100%) E ?U?IIINOON UOIO UA?OIO OI?OAI IA O?AUEO
?IOIA 5 IEIOO IAAIAAAIEN UOIE ?A?AIOIIE EAOOEIU ?OEEIAEOON OOAIN EIA?EUAIE
?UCOOOAOO mysql
OAAIEAA ~70 000 UA?EOAE
?IAOEAOEOA EAE IIA ? OAEIE OEOOAAEE ?IOOO?EOO
UAOAIAA OAIEO
--
aOOAOEII IA ?UAAOOAI ONOAIIE OEUIE - ?UNI AOAIO E UAO?AOIEION....