Re: Create child table question

2002-10-30 Thread Heikki Tuuri
Jannie, - Original Message - From: "Jannie Qu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:18 AM Subject: Create child table question > sql, query, mysql > > Hi, all, > I met a problem with creating the following table: pub_user. > -- Parent table > CRE

Re: Create child table question

2002-10-29 Thread Peter Brawley
Jannie, In CREATE TABLE ... TYPE=InnoDB with a foreign key ref, MySQL seems to want a type def and NOT NULL in the definition of the column to be used as a foreign key. PB - - Original Message - From: "Jannie Qu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29,