Answers for "create table set auto increment"

sql query to make a existing column auto increment

Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY

Posted by: Guest on October-28-2020

set auto increment from 1

SET  @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;

Posted by: Guest on June-10-2020

Code answers related to "create table set auto increment"