How do I increase the "primary key" autoincrement number?

Very simple query:

ALTER TABLE table_name AUTO_INCREMENT=200;

The MySql documentation mentions this in the ALTER TABLE syntax page.

mysql database indexing

You can set the new value of your auto-increment using:

ALTER TABLE table_name AUTO_INCREMENT = 200;

mysql database indexing

Not sure why you would want to, but this should work:

ALTER TABLE table_name AUTO_INCREMENT = 200;

CodeHunter