Hey All,
Sorry for the newbie question, at least I think it is. Here is
my problem. I have 2 tables in my database with the following fields:
names_table and emails_table
name_id (primary key auto increment) email_id (primary key auto
increment)
first_name name_id (foreign key)
last_name email_address
email_type (emum)
Basically a one to many relationship. I have read a few books but am
stumped on one thing, how can I get mysql to keep the name_id's in both
tables the same integer. The name table increments fine but the email
name_id does not increment. I am probably ignorant in saying this but I
thought that since name_id in the emails table would be handled
automatically by mysql since it is a foreign key. Is this a wrong
assumption? Is it the job of the application to do this? Thank you in
advanced for any help/suggestions.
Devin B. Miller
No electrons were hurt in the making of this email.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
