On 07.02.2008 03:52 CE(S)T, Chris wrote:
If you don't mind a mysql-specific "fix", and can get the data you want
from a select query you could:
insert into table (select goes here) on duplicate key update;
or maybe a replace into ?
INSERT/REPLACE ... SELECT will always overwrite the entire row, but I
only want to copy a single column of it. The rest of the record must
remain intact. So I can't use that, too.
I also try to avoid DBMS-specific workarounds where I can in this
project. So maybe one day MySQL will drop the above mentioned
restriction. :)
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
Visit my web laboratory at http://beta.unclassified.de
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
