-----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]

Reply via email to