how to make relation between 2 tables...

hi

i have 2 tables in mysql database and i want to make relation
between the two tables

how to do that in phpmyadmin or any visual tool?



thanks in advance.

how to make relation between 2 tables...
Hi,



%26gt;%26gt;

...how to do that in phpmyadmin

%26gt;%26gt;



even if you could create table relations in PhpMyAdmin
(I can麓t, but that might depend on the version),
I麓d rather suggest doing this by using a ''JOIN'' within your
query -- here麓s a short
tutorial.



%26gt;%26gt;

...or any visual tool

%26gt;%26gt;



there is at least one commercial DW extension available
that麓s providing a sort of ''visual query maker'' tool including
creating such JOINshow to make relation between 2 tables...
MySQL is different from access, in that you have to create
the SQL to join

the tables yourself.



In Microsoft Access, you could drag a join from one table to
another.

Although this is a visual process, all its doing is creating
SQL behind the

scenes to join the tables.



With MySQL you don't have a visual editor, you have to
manually create the

SQL yourself, and theres load of tutorials on the net which
will help you

with this.



--

Gareth


http://www.phploginsuite.co.uk/

PHP Login Suite V2 - 34 Server Behaviors to build a complete
Login system.

quote:

---

Originally posted by:
macnux

hi

i have 2 tables in mysql database and i want to make relation
between the two tables

how to do that in phpmyadmin or any visual tool?



thanks in advance.

---

Download Navicat MySQL it has a visual query builder and can
do alot more.

Get a copy of HeidiSQL also a useful GUI tool.



Cheers