How to set auto increment by 1 on a table in your migration script

Question

ALTER TABLE Table_name AUTO_INCREMENT = 1;

Is it possible to mention this during table creation or after that, in your DB migration scripts.

score 1 · Accepted Answer · answered Nov 26 '12 at 09:19

1

Maybe there are better solutions. Otherwise you can run raw SQL statements in migration scripts like this:

ActiveRecord::Base.connection.execute("ALTER TABLE Table_name AUTO_INCREMENT = 1")

answered Nov 26 '12 at 09:19

Yanhao

1 Answers1