Re: Need Help Setting Relationships

2003-03-07 Thread Chris Montgomery
Disregard my previous msg. It looks like I have it figured out. Friday, March 7, 2003, 5:31:38 PM, Chris Montgomery wrote: > I've looked at the examples, but one thing it doesn't mention is whether > both indexes need to be unique. In the primary table they are, but does > the index in the table

Re: Need Help Setting Relationships

2003-03-07 Thread Chris Montgomery
Howdy Egor, Friday, March 7, 2003, 7:36:00 AM, Egor Egorov wrote: > Both columns Node are indexed, so just add foreign key constraint. You can > find examples in the InnoDB manual: > http://www.innodb.com/ibman.html#InnoDB_foreign_keys I've looked at the examples, but one thing it doesn'

re: Need Help Setting Relationships

2003-03-07 Thread Egor Egorov
On Friday 07 March 2003 00:43, Chris Montgomery wrote: > I have been using MS Access for 5+ years and am new to MySQL. I > understand the theory behind setting relationships between tables, but > am trying to get up to speed in how to do it in MySQL. > > My environment: Win2k and MySQL 3.23.54 > >

Need Help Setting Relationships

2003-03-06 Thread Chris Montgomery
Howdy, I have been using MS Access for 5+ years and am new to MySQL. I understand the theory behind setting relationships between tables, but am trying to get up to speed in how to do it in MySQL. My environment: Win2k and MySQL 3.23.54 Here's what I want to do: I have two tables, categories an