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