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
t: 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
> CREATE TABLE pub_access_type(
> access_type_id INT UNSIGNED NOT NULL,
&g
sql, query, mysql
Hi, all,
I met a problem with creating the following table: pub_user.
-- Parent table
CREATE TABLE pub_access_type(
access_type_id INT UNSIGNED NOT NULL,
access_type_name VARCHAR(25),
PRIMARY KEY(access_type_id)
) TYPE=INNODB;
-- Child table
CREATE TABLE pub_user(
user_id INT UNS
