-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm trying to add a foreign key to a table. All tables are INNODB. Table a has following partial Definition:
TableA ( Fld1 int Primary Key,... ) TableB (Fld2 int Primary Key, Fld1 int not null, ... ) I use the following Statement: Alter Table TableB Add Constraint FK1 (Fld1) References TableA (Fld1) on delete cascade; When I run that statement, I get the following error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SetNo) References BackupSets (SetNo) ON DELETE CASCADE' at lin What am I doing wrong? All help greatly appreciated. - ---Michael -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/GZyUjeziQOokQnARAndkAJ92+Nku97cZldlqnIqDHtZ6s0Xh3wCdGUny hPDeF1ZWYGZVqeczT8XrlGA= =Vo7h -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]