Update Data in a Table with SQL Update

One of the core commands in SQL is update. This is how we can modify the data that is already in our database table. Let’s update our users table and change one of our user's duplicated user handle to a new UUID. We'll even use a postgres extension to generate new UUIDs.

UUIDs / GUIDs

Postgres - http://www.postgresqltutorial.com/postgresql-uuid/

SQL Server- https://docs.microsoft.com/en-us/sql/t-sql/functions/newid-transact-sql?view=sql-server-2017

MySQL - https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html#function_uuid

Oracle - https://docs.oracle.com/javase/8/docs/api/java/util/UUID.html