Re: enrror in foreign key reference

sday, November 25, 2004 12:03 PM Subject: enrror in foreign key reference 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

Re: enrror in foreign key reference

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

enrror in foreign key reference

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