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
valuesALTER TABLE `students`
ADD `uuid_value` VARCHAR(100) NOT NULL AFTER `id`;
Then update the table to assign UUID
valuesUPDATE students
SET uuid_value = UUID();