ALTER TABLE mantis_bug_table AUTO_INCREMENT=1000;

 

 

Thanks  the above command worked for specific databases.

 

But is there any option in command that I can preconfigure issue id to start at

 say p100 for project1 in database1

And to start at c200 for project2 in same database

 and d300 for a subproject of project2 in same database