UUID storage in MySQL


You can store a UUID safely as a “Binary 16”, instead of a “Varchar 36”.

If you still require a human-readable column, its possible to use a “generated” column (from MySQL 5.7 and up):


additional info for MySQL 8.0 –

Retrieve the DNS TTL values

$ dig +nocmd +noall +answer 7139 IN A

Note: If your default DNS server is not the authoritative server for the zone you are digging dig will show the time remaining (until the next refresh) instead of the raw TTL value in this position.

You can work around this by directing dig to specifically use one of the domain’s servers, for example I know that is authoritative for this domain:

$ dig +nocmd +noall +answer 86400 IN A