alter table 테이블명 auto_increment = 1; set @count = 0; //변수만들기 update 테이블명 set 변경할칼럼명 =@count:=@count+1; mysql> alter table guide auto_increment = 1; mysql> set @count = 0; mysql> update guide set gu_num=@count:=@count+1; mysql> select * from guide; +--------+---------+------------+------------+ | gu_num | gu_year | gu_pr_num | gu_st_num | +--------+---------+------------+------------+ | 1 | 2020 ..