Re: enrror in foreign key reference

[Victor Pendleton]

Is there an index on the column in the table referenced?

F.Balicchia wrote:

Hello i'd like to converte this DDL for mysql

ALTER TABLE MYTABLE_ROLE
       ADD  ( FOREIGN KEY (LOGIN)
                             REFERENCES MYTABLE_USER ) ;
------------

i wrote

ALTER TABLE MYTABLE_ROLE
    ADD FOREIGN KEY (LOGIN) REFERENCES MYTABLE_USER ;

by it return me this error.
#1005 - Can't create table '.\mydb\#sql-4b4_63.frm' (errno: 150).

I don't understand how i can resolve it.

thanks

--Filippo

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]