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):

Source: https://mysqlserverteam.com/storing-uuid-values-in-mysql-tables/

additional info for MySQL 8.0 – https://mysqlserverteam.com/mysql-8-0-uuid-support/

Precedence for the Commandline $PATH

On the commandline the elements of PATH are checked from left to right.

an example (PATH)

the command test-my-command-precedence.sh which exists in

for the following path


the /usr/bin/test-my-command-precedence.sh gets precedence.