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
CREATE TABLE
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
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,
access_type_name VARCHAR(25),
PRIMARY KEY(access_type_id)
) TYPE