SQL Problem

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?

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

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. :)

Try a migration:

Code:

---

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

---

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,

Quote:

---

Originally Posted by 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,

---

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

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

Is that right?

Quote:

---

Originally Posted by NickToye

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).

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

Which IDE are you using btw? Looks sharp :)