SQL: como puedo borrar un registro y todos los valores asociados a el en otras tablas

Article View: es.comp.bd.ms-access

Article #3

Back to es.comp.bd.ms-access Previous Next

From: Eduardo Quiroz Salinas
Date: Tue, 20 Apr 2004 19:16

13 lines
1627 bytes

exist�a parece un DELETE ON CASCADE pero no se si funciona en mysql 4.
alguein sabe aquello?
-- 
Linux user number 344659

"...Los que no requieren de un dios para ser virtuosos,
son la desesperacion de los creyentes..."

-------------------------------
Eduardo Quiroz Salinas
09-5149349
eduardoquiroz@vtr.net
-------------------------------

Technical Details

Message-ID: <c63su8$78c$1@news1.nivel5.cl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: SPANISH,ASCII
X-Google-Thread: f9ea8,367cb76b8578fd2c,start
X-Google-Attributes: gidf9ea8,public
X-Google-Thread: 111a5a,367cb76b8578fd2c,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 1593cb,367cb76b8578fd2c,start
X-Google-Attributes: gid1593cb,public
X-Google-ArrivalTime: 2004-04-20 12:16:24 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail
From: Eduardo Quiroz Salinas <eduardoquiroz@vtr.net>
Newsgroups: es.comp.bd.ms-access,chile.comp.programacion,chile.comp.pc
Subject: SQL: como puedo borrar un registro y todos los valores asociados
 a el en otras tablas
Date: Tue, 20 Apr 2004 15:16:21 -0400
Organization: Varios
Lines: 14
Message-ID: <c63su8$78c$1@news1.nivel5.cl>
NNTP-Posting-Host: cm-lflo3-118-161.cm.vtr.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: news1.nivel5.cl 1082488584 7436 200.120.118.161 (20 Apr 2004 19:16:24 GMT)
X-Complaints-To: news@news1.nivel5.cl
NNTP-Posting-Date: Tue, 20 Apr 2004 19:16:24 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3
X-Accept-Language: en-us, en