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
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 reply
but in manual there's
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