can u please post your sql along with the error message
On 5/19/08, arunkumar <[EMAIL PROTECTED]> wrote:
>
> If a single reference in my table it is working..but it is showing error no
> 150, when I refer multiple foreign keys..is there any change in
> syntax?...help me
>
>
>
>
>
>
>
>
>
>
>
>
>
>
If a single reference in my table it is working..but it is showing error
no 150, when I refer multiple foreign keys..is there any change in
syntax?...help me
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
--
MySQL General Mailing List
For list archives
`) REFERENCES `test.test_product` (`prod_id`) ON
DELETE SET NULL
) TYPE=InnoDB |
Note that, there is two foreign keys reference prod_id. Is there some
problem with the multiple references to the prod_id? or is this fine?
I think the second one "FOREIGN KEY (`prod_id`) REFERENCES
`test.test_
