FAQ

Yves Goergen wrote:
On 06.02.2008 08:12 CE(S)T, Chris wrote:
Yves Goergen wrote:
My goal was to copy some potentially large BLOB from one record to
another in the same table
Update table set blob2_field=blob1_field;
This does something totally different. ;) See my first posting why.
Ah I missed the first post.

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 ?

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 7 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