How can I append/concatenate BLOB data to a BLOB column using update?

Question

I need to append data to my BLOB field, how can I do this using an update? What I am asking is; is it possible to concatenate blob data so that I can update a blob field with this new data. Something like:

UPDATE BLOB_table 
   SET BLOB_field = BLOB_field + BLOB_data

barsju · Accepted Answer · 2012-03-20 13:05:00Z

6

Concat should work..

UPDATE BLOB_table SET BLOB_field = CONCAT(BLOB_field, BLOB_data);

I tested with this:

CREATE TABLE `Blobs` (
  `id` int(11) NOT NULL,
  `b` blob,
  PRIMARY KEY  (`id`)
) 

insert into Blobs values (1, "heel");

update Blobs set b = concat(b, "heelele");

Maybe this just works since I paste strings into the Blob...

edited Mar 20, 2012 at 13:05

answered Mar 20, 2012 at 12:39

barsju

4,4561 gold badge23 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Avinash Over a year ago

No, its not working for me. If you have some code snippet then please share.

barsju Over a year ago

Looks like someone else has made it work: grokbase.com/t/mysql/mysql/996xt29byb/blobs-and-concat

Christopher Schultz Over a year ago

This often runs into the error "Result of CONCAT exceeds max-packet_size". Basically, it's not possible to stream large data into and out of MySQL/MariaDB.

Collectives™ on Stack Overflow

How can I append/concatenate BLOB data to a BLOB column using update?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related