[Ilugc] Help in MySQL

From: lug@xxxxxxxxxxxxxxxxxx (Chandrashekar Babu)
Date: Fri Aug 12 10:37:08 2005

On Fri, 12 Aug 2005 09:20:52 +0530, Aravindakshan M R
<digivind@xxxxxxxxxxxxxx> wrote:

Can anybody pls tell, how do i connect 2 tables withforeign key using
common fields.....
If i delete one row on table 1 then it shouldautomatically cascaded with
a deletion of thecorresponding row in table 2.....

The following link should help you [first hit from
google search i.e.]:

http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html

--
Chandrashekar Babu.
http://www.chandrashekar.info/

References:
- [Ilugc] Help in MySQL
  - From: Aravindakshan M R

Other related posts:

» [Ilugc] Help in MySQL- Aravindakshan M R
» [Ilugc] Help in MySQL - Chandrashekar Babu
» [Ilugc] Help in MySQL- Binand Sethumadhavan
» [Ilugc] Help in MySQL- Vamsee Kanakala