Varakorn Ungvichian wrote:
--- 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.
Which is parsed but silently ignored for non-InnoDB tables <http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html>, so it won't be there in SHOW CREATE TABLE output. InnoDB tables support this, but you have to have the index(es) in place for it to work. See the manual for more <http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html>.
Varakorn Ungvichian
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
