I have a table with two fields that reference the same field in another table. Is this allowed (I'm not sure if it is). mysql 3.23.46 allows this, but apparently, mysql 3.23.47 does not. Create it with just one key and it's fine. Reference different tables and it's fine.
mysql-3.23.47 InnoDB tables under Sparc Solaris 8 mysql> create table test_base ( fld int not null ); Query OK, 0 rows affected (0.07 sec) mysql> create table test_fk ( fld1 int not null, fld2 int not null, foreign key (fld1) references test_base(fld), foreign key (fld2 references test_base(fld) ); ERROR 1064: You have an error in your SQL syntax near 'references test_base(fld) )' at line 1 mysql> create table test_fk ( fld1 int not null, fld2 int not null, foreign key (fld1) references test_base(fld), foreign key (fld2) references test_base(fld) ); ERROR 1005: Can't create table './test/test_fk.frm' (errno: 150) mysql> * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php