Re: Programming for referential integrity

2001-12-28 Thread Mike Eggleston
> To: <[EMAIL PROTECTED]> Sent: Friday, December 28, 2001 2:05 PM Subject: Programming for referential integrity > Hello, > Forgive me for what is probably a fairly novice question as I am still > fairly new to MySQL. I have constructed the following database with > thre

Programming for referential integrity

2001-12-28 Thread Matt Rudderham
Hello, Forgive me for what is probably a fairly novice question as I am still fairly new to MySQL. I have constructed the following database with three tables: CREATE TABLE members ( member_id int DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY, first varchar(20) NOT NULL, last varchar(20)