UUID
UUID
generates unique string combined with 32 alphanumeric symbols like:
8b652b09-8bb8-11eb-b0ac-b4b52f79163f
UUID
stands for Universally Unique IDentifier and is designed to be unique inside table, across different tables, databases and even servers. Let's add one column
uuid_value
to
students
table for
UUID
values
ALTER TABLE `students` 
ADD `uuid_value` VARCHAR(100) NOT NULL AFTER `id`;
Then update the table to assign
UUID
values
UPDATE students
SET uuid_value = UUID();
by Valeri Tandilashvili
4 years ago
MySQL
UUID
1
Pro tip: use ```triple backticks around text``` to write in code fences