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! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
What database? If it''s mysql, you can use alter table like this: ALTER TABLE t2 AUTO_INCREMENT = /|value|/; -Bill Guillaume Loader 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." "<judge>...and here is a picture of your private parts.</judge> <defendant>That''s when he stoled my phone.</defendant>" - Anonymous Quotes from Daytime Judge Shows --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Yes I know but with rails we never change the Db manually right?? We use migrations? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 Loader 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." "<judge>...and here is a picture of your private parts.</judge> <defendant>That''s when he stoled my phone.</defendant>" - Anonymous Quotes from Daytime Judge Shows --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---