Tweeted twitter.com/StackDBAs/status/940908588398252032
2 minor cleanup
source | link

MySQL align Align auto increment index to next thousand

I am using MySQL.

When applying a big change to a production database, iI would like to change the next auto-increment next 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?

MySQL align auto increment index to next thousand

I am using MySQL

When applying a big change to a production database, i would like to change the auto-increment next 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?

Align auto increment index to next thousand

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?

    Post Migrated Here from serverfault.com
1
source | link

MySQL align auto increment index to next thousand

I am using MySQL

When applying a big change to a production database, i would like to change the auto-increment next 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?