I'd like to insert some rows into a table using an SQL-script but the table key is an Ulid. Is there a way to generate Ulids in MySQL? It's not build-in as far as I know and Google does not come up with any community provides solutions either so I wonder if it's possible at all.
1 Answers
You can get the binary form of a ULID with this in MySQL:
CONCAT(UNHEX(CONV(ROUND(UNIX_TIMESTAMP(CURTIME(4))*1000), 10, 16)), RANDOM_BYTES(10))
And you can get the canonical string representation with theses functions defined at https://gist.github.com/kenji4569/47ce8bbd6bef7b85ba1f97e018f34cf3
Related