From: Martijn Tonies
Date: June 17 2008 10:10am
Subject: Re: delete a data from 3 tables
List-Archive: http://lists.mysql.com/mysql/213379
Message-Id: <014a01c8d062$5771b020$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

>I created 3 tables namely authen_tbl,profile_tbl,astro_tbl,in which column
name mail as primary key in authen_tbl table ,
>query:
>pid int primary key auto_increment,
>foreign key (mail) references authen_tbl(mail)
>given in astro_tbl table
>and
>query
>foreign key(pid) references profile_tbl(pid)
>given in astro_tbl.
>
>My problem is how to delete a data at a strech from 3 tables.

Issue a DELETE command?

What exactly is your -problem- ...

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com