rash
rash

Reputation: 11

How to Insert blob data in mysql

I want to insert blob data into MySQL database. I am aware of LOAD_FILE but it's not fitting my requirements. Also tried inserting hex value:

INSERT INTO table VALUES (1, x'6210341GG80JF803080G40GG2000000000002400000000001GO0K1G85A34HJHT0G1G4C0Q645J02860DAG82OC08O3EC8B604GC0QL0G1GO0');

But it didn't work.

Upvotes: 1

Views: 4000

Answers (1)

Racil Hilan
Racil Hilan

Reputation: 25341

Use a valid hex value. The value in the question is not valid.

I also suggest that you remove the single quotes and add zero before the x:

INSERT INTO table VALUES (1, 0x6210341fab6210341);

Upvotes: 1

Related Questions