Filippo,
you used a FOREIGN KEY syntax that MySQL/InnoDB does not support.
Look at the correct syntax here:
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a
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
