--- Michael Stassen <[EMAIL PROTECTED]> wrote: > > Varakorn Ungvichian wrote: > > 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 > > Well, of course not. It won't show them until you > create them, which you > haven't done according to #2.
I'm thinking more along the terms of when I include something like "position_id tinyint(4) NOT NULL default 1 references positions (position_id)" in the "create table" statement. Varakorn Ungvichian __________________________________ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]