How to use a primary key different from `id'?

[Quique _]

Thank you very much for this informative article.

I have a question though:
what should I do if I don't want the primary key to be `id', but some other attribute?

Example:

CREATE TABLE products (
name varchar(100),
description text,
PRIMARY KEY (name)
) ENGINE=INNODB;

Thanks!