Re: How to retrieve constraints and links from MySQL tables?

[Varakorn Ungvichian]

--- Michael Stassen <Michael.Stassen@stripped>
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