MySQL Forums
Forum List  »  PHP

Re: relationship and tables.
Posted by: Markus Popp
Date: July 19, 2005 03:02PM

You can do it like this:

CREATE TABLE `table_a` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(5) NOT NULL,
UNIQUE KEY `name` (`name`)
) TYPE=InnoDB;

CREATE TABLE `table_b` (
`id` int(11) NOT NULL auto_increment,
`id_a` int(11) NOT NULL,
`number` int(11) NOT NULL,
KEY `id_a` (`id_a`)
) TYPE=InnoDB;

ALTER TABLE `table_b`
ADD CONSTRAINT `table_b_ibfk_1` FOREIGN KEY (`id_a`) REFERENCES `table_a` (`id`);

Take care that you have to use InnoDB tables to make this work.

This works for all relation types, but you should never make a n:n relation. Instead you should split it into 2 (or more, if necessary) tables with 1:n relation.

Markus Popp, Web Developer,
Oracle Austria

Options: ReplyQuote

Written By
July 19, 2005 02:20PM
Re: relationship and tables.
July 19, 2005 03:02PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.