FAQ

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" <nospam.list@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 8 of 8 | next ›
Discussion Overview
groupmysql @
categoriesmysql
postedFeb 5, '08 at 4:26p
activeFeb 7, '08 at 11:06a
posts8
users4
websitemysql.com
irc#mysql

People

Translate

site design / logo © 2021 Grokbase