sql DB Query changing PK value

Question

my DB i want to change all the tables primary key a specific number incriment 9 how can do it with one query

Nanhe Siddique · Answer

i think you want to change default increment value of primary key. if i am write. write following wuery ALTER TABLE `users` AUTO_INCREMENT = 9 this command change auto increment from 1 to 9 i hope it will help you

Anupam Singh · Answer

You have to remove primary key constraint from column and update values after updating values you can make the same column primary key. I am not 100% sure but try with sample table first.