using constraint - kathryn kasprow - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlusing constraint

From	Sent On	Attachments
kathryn kasprow	08 Dec 1999 11:07
Sasha Pachev	08 Dec 1999 17:34

Subject:	using constraint
From:	kathryn kasprow (ngov...@hotmail.com)
Date:	12/08/1999 11:07:18 AM
List:	com.mysql.lists.mysql

Hi,

I used constraint for the table as followed:

alter table assigned add ( constraint assigned_fk (prodno) references course (prodno) on delete cascade ), add ( constraint assigned_fk (Mlogin) references manager (Mlogin) on delete cascade ));

the error message: you have an error in your sql syntax near '( constraint assigned_fk foreign key (prodno) references course (prodno) on dele' at line1

Please help, thanks for advance!