Hi,

How do I set a relationship between two tables?

I have created a database in MySQL, and have created two tables within this database. Each table has an ID field which is set as Primary Key. Now I wish to 'relate' a field in one table to a field in the other table. I'd like to know how to do this using the phpMyAdmin utility and how it would be done at a command line. I get the feeling this is really simple, just can't figure it out, or using wrong syntax.

Thanks in advance.

I assume that by "relate" you mean establish a "foreign key". MySQL doesn't have foreign keys. See here for details.

Bill Dimm, MagPortal.com - [:red]free feeds for your site.