What is wrong with this create statement?
I have the following query:
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?
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