Update Data in a Table with SQL Update

Tyler Clark
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.


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