Example Sql for add primary key with auto increment to existing table column mysql-446138

Search

SCRIPT & CODE EXAMPLE

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;

Source by stackoverflow.com #

PREVIOUS	NEXT

Tagged: #add #primary #key #auto #increment #existing #table #column #mysql

ADD COMMENT