setting a KEY and not a PRIMARY KEY?

[Ricardoskate]

i have a newbie question

how can i set a KEY value and not a PRIMARY KEY??
i need to do this:

CREATE TABLE comments (
Â* 'id' int(10) unsigned NOT NULL auto_increment,
Â* 'user' int(10) unsigned NOT NULL default '0',
Â* 'torrent' int(10) unsigned NOT NULL default '0',
Â* 'added' datetime NOT NULL default '0000-00-00 00:00:00',
Â* 'text' text NOT NULL,
Â* 'ori_text' text NOT NULL,
Â* PRIMARY KEYÂ* ('id'),
Â* KEY user ('user'),
Â* KEY torrent ('torrent')
) TYPE=MyISAM;

help please...
when i try to do this manually i get a sintaxis error
thnx in advance

[Xnuiem]

There isnt a "KEY" in MySQL, its an INDEX. MySQL does not reconize FK's like Oracle or Sybase

[Ricardoskate]

Originally posted by Xnuiem@Aug 19 2004, 02:18 PM
There isnt a "KEY" in MySQL, its an INDEX. MySQL does not reconize FK's like Oracle or Sybase

then i have to put it at INDEX??
or PRIMARY KEY??
:unsure: