SQL Problem

[NickToye]

Hi,

I am trying out this tutorial:

http://www.rails4days.pwp.blueyonder...Rails4Days.pdf

CREATE TABLE 'categories' (
'id' smallint(5) unsigned NOT NULL auto_increment,
'category' varchar(20) NOT NULL default '',
'created_on' timestamp(14) NOT NULL,
'updated_on' timestamp(14) NOT NULL,
PRIMARY KEY ('id'),
UNIQUE KEY 'category_key' ('category')
) TYPE=MyISAM COMMENT='List of categories';

It gives me an error, saying SQL execution error # 1064.

Anyone know why?

[vgarcia]

If you're using a version of MySQL greater than 4.1 you have to use ENGINE=MyISAM, not TYPE.

[NickToye]

ok, however it is still giving me an error:

I have attached a screenshot.

Also, I wasn't sure if this should have gone in MySQL or Ruby, because it was a ruby tutorial, I thought it may have gone there.

[Fenrir2]

Try a migration:

create_table :categories do |t|
    t.column :category, :string
    t.column :created_on, :datetime
    t.column :updated_on, :datetime
end

[NickToye]

What's a migration?

Also I would like to use this SQL, because i'm following a tutorial and I don't really want to sidestep it,

[vgarcia]

What's a migration?

Also I would like to use this SQL, because i'm following a tutorial and I don't really want to sidestep it,

Migrations are the preferred way to work with databases in Rails now, since a migration isn't DBMS-specific.

[NickToye]

Yeah, so its a more simplified way of creating SQL, or a more Rails/Ruby native way of creating data.

Is that right?

[vgarcia]

Yeah, so its a more simplified way of creating SQL, or a more Rails/Ruby native way of creating data.

Is that right?

Both, with the added benefit of being portable (i.e. for the most part you'd be able to use the same migration for SQLite or MySQL or SQL Server).

[NickToye]

It looks good, I like the fact that it makes logical sense too.

[Viflux]

Which IDE are you using btw? Looks sharp