How can i insert a BLOB in mysql trough query

Question

Does anyone know how i can enter an integer or hexadecimal value into a BLOB in mysql?

The endresult that i need is that the binary data of my blob contains:

Offset       1    2   3   4   5   6   7   8   9   A   B  C  D  E  F
___________________________________________________________
0x00000000   15  AA   02  00  00  00  00  00  00  00  00 00 00 00 00

The current blob holds the value : 174613

So how would i write an insert/update query to put that value into this BLOBb?

YoungHobbit · Accepted Answer · 2015-12-26 05:44:19Z

2

Found a solution:

insert into tablename(columnname) values(x'15AA02000000000000000000000000')

columnname has to be of type BLOB.

edited Dec 26, 2015 at 5:44

YoungHobbit

13.4k9 gold badges53 silver badges76 bronze badges

answered Dec 26, 2015 at 5:40

MGDsoft

1211 silver badge4 bronze badges

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

Collectives™ on Stack Overflow

How can i insert a BLOB in mysql trough query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related