This is actually one of the more common MySQL problems which doesn't have an
easy answer.
The best I can offer is a bit of a kludge... but it does work. The trick is
to use the Replace...Select command. The problem with this is that you can
not select from the table you are replacing. But if y
alue as a new record on a unique index, the old record is deleted
before the new record is
inserted"
Niklas
-Original Message-
From: m0sh3 [mailto:[EMAIL PROTECTED]]
Sent: 2. marraskuuta 2001 13:37
To: Niklas Lampén
Subject: Re: [PHP-DB] UPDATE table1 FROM table2
thanx for
Yes, it is possible:
UPDATE TABLE2 SET (Field1, Field2, Field3)
SELECT UpdaterField1, UpdaterField2, UpdaterField3 FROM TABLE1
WHERE SomeField LIKE 'Something'
WHERE SomeField LIKE 'Something'
That should work. Manual tells you more in Update section.
Niklas
-Original Message