How can a GUID be converted from CHAR(36) to BINARY(16) in MySQL 5.7?

I

Ivan Melnikov2018-03-28 07:41:51

MySQL

Ivan Melnikov, 2018-03-28 07:41:51

A third-party application writes a GUID to the database in the format 6F9619FF-8B86-D011-B42D-00CF4FC964FF. How to convert this format to BINARY (16) before insert and write it to the database already?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

T

twittoponchik2022-01-07 12:30:00

Can I withdraw money from AdSense to my IP if the application is posted on Google Play on behalf of an LLC? 5Reply

R

Roman Tuzov2021-03-22 23:47:34

How to count from 0 and beyond? 3Reply

R

Rooly2021-03-23 11:40:40

How to properly organize apiResource Laravel? 2Reply

T

tmnovice2015-11-29 19:30:56

Updating data in mysql vs.? 1Reply

S

Sergey Korenevsky2018-04-07 06:03:40

How to save query hits for MySQL per time interval? 1Reply

Didn't find what you were looking for?

Ask your question