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 CREATE TABLE

Create child table question

2002-10-29 Thread Jannie Qu
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

Re: Create child table question

2002-10-29 Thread Peter Brawley
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