How to insert a binary value into mysql

Question

Is there a flag to indicate that data is of binary type, or does that need to be converted to another type. For example, is there a way to do:

INSERT INTO mytable (number) VALUES (0000 0010)

Instead of:

INSERT INTO mytable (number) VALUES (2)

I know the above is a trivial example but basically I'm wondering if you can type a binary/hex value directly into a query.

Barmar · Accepted Answer · 2020-03-23 04:27:47Z

4

INSERT INTO mytable (number) VALUES (b'00000010');
or
INSERT INTO mytable (number) VALUES (0b00000010)

answered Mar 23, 2020 at 4:27

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

1 Answer 1