5. 5
    Update Data in a Table with SQL Update
    2m 3s

Update Data in a Table with SQL Update

InstructorTyler Clark

Share this video with your friends

Send Tweet

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