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 ?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to