I am using MySQL.
When applying a big change to a production database, I would like to change the next auto-increment index of all my tables to align them to the next available thousand.
In other words, for each table, make the next new row in that table bear an ID that is 1000-aligned.
That would make it easier for humans to detect pre- and post-migration records without impairing DB functionality.
Is there a quick automated way to do that? More importantly, is there an important drawback I missed?