Change the start of auto_increment?


#1

Hello everyone!

I have a table, “posts”. And I want to start the id from 1000. Is that
possible?
Do I need a migration?

Thank your for your help!


#2

What database? If it’s mysql, you can use alter table like this:

ALTER TABLE t2 AUTO_INCREMENT = /|value|/;

-Bill

Guillaume L. wrote:

Hello everyone!

I have a table, “posts”. And I want to start the id from 1000. Is that
possible?
Do I need a migration?

Thank your for your help!


“She was attempting to bicycle kick me when she raised her butt up and
farted on me your honor.”
“I have a list of all the dvd’s she had tooken…”
“I called him because I was mad that he was spreadin my famly business
round the trailer court…”
“She said she had no money for rent but she was makin money strippin”
“…they just completely at the point being turmoiled my life.”
“…when the motor blowed up 2 months ago.”
“I basically furnitured the whole house.”
“I started the conversate on MySpace.”
“I axed her what a lace from wig was and she axed me to come in for a
consertation…”
“He is the emotionalist man I eva seen…”
“…it literally ranned over my car. I mean, it may be a 2002 DaeWoo,
but it’s ma ride.”
“…and here is a picture of your private parts.
That’s when he stoled my phone.”

  • Anonymous Quotes from Daytime Judge Shows

#3

Yes I know but with rails we never change the Db manually right?? We use
migrations?


#4

Uhh, I wouldn’t say never. If you want to do it with a migration you
will just have to execute the sql from the migration. Afaik, there is no
special way to do this in a migration.

http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/DatabaseStatements.html#M001887

-Bill

Guillaume L. wrote:

Yes I know but with rails we never change the Db manually right?? We use
migrations?


“She was attempting to bicycle kick me when she raised her butt up and
farted on me your honor.”
“I have a list of all the dvd’s she had tooken…”
“I called him because I was mad that he was spreadin my famly business
round the trailer court…”
“She said she had no money for rent but she was makin money strippin”
“…they just completely at the point being turmoiled my life.”
“…when the motor blowed up 2 months ago.”
“I basically furnitured the whole house.”
“I started the conversate on MySpace.”
“I axed her what a lace from wig was and she axed me to come in for a
consertation…”
“He is the emotionalist man I eva seen…”
“…it literally ranned over my car. I mean, it may be a 2002 DaeWoo,
but it’s ma ride.”
“…and here is a picture of your private parts.
That’s when he stoled my phone.”

  • Anonymous Quotes from Daytime Judge Shows