Change value for a PK column with AUTO_INCREMENT in mysql
· One min read
<code class="sql">show create table TABLE_NAME; // Check current AUTO_INCREMENT value
update IGNORE TABLE_NAME set primary_field = 'value' ...; // Change the column value with IGNORE keyword
alter table TABLE_NAME AUTO_INCREMENT = 50; // Set AUTO_INCREMENT
show create table TABLE_NAME; // Check current AUTO_INCREMENT value again
