CODE EXAMPLE FOR SQL

add primary key with auto increment to existing table column mysql

add primary key with auto increment to existing table column in mysql


#ALTER table user_info MODIFY id int(15) PRIMARY KEY AUTO_INCREMENT;
#ALTER table user_info drop PRIMARY KEY;