Skip to content

Instantly share code, notes, and snippets.

@ekos

ekos/update_auto_increments_2.sql

Created April 25, 2017 06:28
Show Gist options
  • Save ekos/84e5a120bc9ac1e3ede10854c4822bf6 to your computer and use it in GitHub Desktop.
Save ekos/84e5a120bc9ac1e3ede10854c4822bf6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update_auto_increments_2.sql
ALTER TABLE hogehoge ENGINE = MyISAM;
ALTER TABLE hogehoge AUTO_INCREMENT = 10;
ALTER TABLE hogehoge ENGINE = InnoDB;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment