» First and foremost, change the data type of the id column in the users table to INT.
alter table users modify column id int;
» Conduct to add primary key constraint to the id column in the users table, ensuring each id value uniquely identifies a record.
alter table users add primary key (id);
» Finally, set the data type of the id column to INT and configures it to auto-increment, ensuring that each new row inserted into the table receives a unique identifier.
alter table users modify column id int auto_increment;