2 messages in com.mysql.lists.mysqlusing constraint
FromSent OnAttachments
kathryn kasprow08 Dec 1999 11:07 
Sasha Pachev08 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!

MH