How to Insert blob data in mysql

Question

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.

when querying it fails

rash
– rash

2017-11-07 14:24:29 +00:00
Commented Nov 7, 2017 at 14:24 — rash
– rash, Commented Nov 7, 2017 at 14:24

Racil Hilan · Accepted Answer · 2017-12-22 15:24:02Z

1

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);

edited Dec 22, 2017 at 15:24

answered Nov 7, 2017 at 13:04

Racil Hilan

25.4k13 gold badges56 silver badges61 bronze badges

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

2 Comments

rash Over a year ago

I am getting this error - ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Racil Hilan Over a year ago

That's because the value you have is not hex value. I copied it from your question thinking it was correct and didn't pay attention. Hex values only include a-f characters, but your other invalid characters like G, K. O, Q, etc. Where did you get that value from? Use a valid hex value and query will work.

Collectives™ on Stack Overflow

How to Insert blob data in mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related