Hello!
Simon Green wrote:
>What I am trying to do in MySQL.
>
>Table1
>
>UserID ProductID Old_UserID
>1 2 4
>2 3 5
>
>Table2
>UserID ProductID
>4 Null
>5 Null
>
>Table1 has new correct data.
>Table2 has old incorrect data.
>The link is Table2.UserID and Old_UserID
>
>What I need to do is update Table 2 with the new data from Table 1,
>But I can not get this to work..e.g.
>
>UPDATE Table2.ProductID
>SET Table2.ProductID = Table1.ProductID
>WHERE Table1.Old_UserID = Table2.UserID
>
>REPLACE will not work as these are not KEY fields.
>Once I have done the ProductID I should then be able to do the UserID using
>the ProductID (as all values in one table are unique).
>
>
SELECT
concat('UPDATE Table2 SET ProductID = ',
t1.ProductID,
' WHERE UserID = ',
t1.UserID,
';'
)
INTO OUTFILE
'/tmp/update.sql'
FROM
Table1 t1
LEFT JOIN Table2 t2 ON (t1.Old_UserID = t2.UserID)
WHERE
t2.UserID IS NOT NULL
;
\. /tmp/update.sql
This might help...but better take a look at /tmp/update.sql, before
executing it!!!
Greetings
Ralf
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109 Kiel, Germany
fon: +49 431 660 97 0, fax: +49 431 660 97 20
mailto:[EMAIL PROTECTED], http://www.splendid.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
