What is wrong with this create statement?

[Hartmann]

I have the following query:

 CREATE TABLE special(
sp_p_id int( 5 ) NOT NULL ,
sp_desc text NULL ,
sp_rates set( 'true', 'false' ) NOT NULL DEFAULT 'true',
sp_home set( 'true', 'false' ) NOT NULL DEFAULT 'false',
FOREIGN KEY sp_p_id REFERENCES product( p_id ) ON DELETE CASCADE
) TYPE = InnoDB

The 'product' table already exsists with the p_id field being the primary key. I get a 1064 error near 'REFERENCES product(p_id) ON DELETE CASCADE'. Anyone have an idea as to why I am getting this error?

[swampBoogie]

FOREIGN KEY (sp_p_id) REFERENCES product( p_id ) ON DELETE CASCADE

[MattR]

If the above does not work make sure your MySQL version supports ON DELETE .. ,

[Hartmann]

Yeah, it was the () around sp_p_id... I caught it about 10 minutes after I made the post.

Now I have to figure out how to implement foreign keys since my host doesn't support InnoDB