I''ve been creating my tables using the command line approach Dave advocates in AWD. I just noticed that they''re being created as MyISAM-type tables. I remember reading (but not where) that I should be creating these as InnoDB-type tables. So, two questions... 1) Is the table type important? (a "why" component to the answer would be nice too ;-) ) 2) If so, is there a way to specify the table type using the command line approach? Thanks in advance, Bill -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060314/ea8648da/attachment.html
InnoDB supports transactions... MyISAM does not. CREATE TABLE tblname ( columndefs... ) ENGINE=InnoDB http://dev.mysql.com/doc/refman/4.1/en/create-table.html b Bill Walton wrote:> I''ve been creating my tables using the command line approach Dave > advocates in AWD. I just noticed that they''re being created as > MyISAM-type tables. I remember reading (but not where) that I should be > creating these as InnoDB-type tables. So, two questions... > > 1) Is the table type important? (a "why" component to the answer would > be nice too ;-) ) > > 2) If so, is there a way to specify the table type using the command > line approach? > > Thanks in advance, > Bill > > > ------------------------------------------------------------------------ > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails
Thank you, Ben. Very much. Best regards, Bill ----- Original Message ----- From: "Ben Munat" <bent@munat.com> To: <rails@lists.rubyonrails.org> Sent: 2006-03-14 9:18 PM Subject: Re: [Rails] specifying table type> InnoDB supports transactions... MyISAM does not. > > CREATE TABLE tblname ( > columndefs... > ) ENGINE=InnoDB > > http://dev.mysql.com/doc/refman/4.1/en/create-table.html > > b > > > Bill Walton wrote: > > I''ve been creating my tables using the command line approach Dave > > advocates in AWD. I just noticed that they''re being created as > > MyISAM-type tables. I remember reading (but not where) that I should be > > creating these as InnoDB-type tables. So, two questions... > > > > 1) Is the table type important? (a "why" component to the answer would > > be nice too ;-) ) > > > > 2) If so, is there a way to specify the table type using the command > > line approach? > > > > Thanks in advance, > > Bill > > > > > > ------------------------------------------------------------------------ > > > > _______________________________________________ > > Rails mailing list > > Rails@lists.rubyonrails.org > > http://lists.rubyonrails.org/mailman/listinfo/rails > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails
Ben Munat wrote:> InnoDB supports transactions... MyISAM does not. > > CREATE TABLE tblname ( > columndefs... > ) ENGINE=InnoDB > > http://dev.mysql.com/doc/refman/4.1/en/create-table.html > > bOr, with migrations... create_table "tblname", :force => true, :options => "ENGINE=InnoDB" do |t| t.column "colname", :integer #... end --josh -- Posted via http://www.ruby-forum.com/.