Hi, I am trying two create two innodb tables:
1. CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL, PRIMARY KEY(COD)) TYPE=INNODB; 2. CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES FIRST(COD)) TYPE=INNODB; The second table cannot be created (errno: 150) Thanks in advance for help! Pierre --------------------------------------------------------------------- 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
