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.