Reputation: 11
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
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