User Tools

Site Tools


mysql:storing_uuid

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
mysql:storing_uuid [2016/11/21 10:18] – created petermysql:storing_uuid [2020/07/15 09:30] (current) – external edit 127.0.0.1
Line 10: Line 10:
 </code> </code>
  
-In order to store the UUID properly, the dashes should be removed and the UUID converted from hexadecimal representation to its binary form.  This could be done in a single step with: UNHEX(REPLACE('id', '-', '')).  Loading it from the a file could be done this way:+In order to store the UUID properly, the dashes should be removed and the UUID converted from hexadecimal representation to its binary form.  This could be done in a single step with: <nowiki>UNHEX(REPLACE('id', '-', ''))</nowiki>.  Loading it from the a file could be done this way:
  
 <code bash> <code bash>
mysql/storing_uuid.1479723535.txt.gz · Last modified: 2020/07/15 09:30 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki