Just realised something: my table was MyIsam. I
switched it to InnoDB (which support FKs), but now:
1. "Show Create Table" still doesn't show reference
links, and
2. I can't seem to make foreign keys, because it
generates the error: "ERROR 1005: Can't create table
'.\ltab\#sql-60c_11.frm' (errno: 150)". It happens
through both defining it as part of Create Table, and
trying to add it later with Alter Table ("alter table
employees add foreign key (position_id) references
positions(position_id);").
Varakorn Ungvichian
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
