Article View: chile.comp.programacion
Article #3910Re: SQL: como puedo borrar un registro y todos los valores asociados a el en otras tablas
From: Cristian Gutierrez
Date: Thu, 22 Apr 2004 04:21
Date: Thu, 22 Apr 2004 04:21
19 lines
2740 bytes
2740 bytes
Eduardo Quiroz Salinas wrote: [...] > pu�$&$$%&$/(% > la consulta se me ejecuta correctamente. Verifique q la tabla > estuviera en innodb, pero no funcion�.... :( > que podr� ser?? > tengo que borrar primero la foreign key que ya est� creada?? > cuando lo intento hacer no me lo permite... > uf. algo de help please. Funciona si partes de cero en otra tabla? -- Cristian Gutierrez http://www.dcc.uchile.cl/~crgutier crgutier[@]dcc.uchile.cl Jabber:crgutier@jabber.org BTW, FWIW, IMHO, AFAIK, yes. OTOH, AAMOF, maybe not. YMMV.
Technical Details
Message-ID:
<871xmgfxsd.fsf@guti.no-ip.org>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.yul.equant.net!news-santiago!helcaraxe.dcc.uchile.cl!guti.no-ip.org!newsReferences:
<c63su8$78c$1@news1.nivel5.cl> <87r7uiufiu.fsf@guti.no-ip.org> <c650e2$krv$1@news1.nivel5.cl> <87n055vqe4.fsf@guti.no-ip.org> <c66lfb$32i$1@news1.nivel5.cl> <c66ptb$32i$3@news1.nivel5.cl>Show Full Headers
Complete Article Headers
X-Google-Language: SPANISH,ASCII X-Google-Thread: f9ea8,367cb76b8578fd2c X-Google-Attributes: gidf9ea8,public X-Google-Thread: 1593cb,367cb76b8578fd2c X-Google-Attributes: gid1593cb,public X-Google-ArrivalTime: 2004-04-21 21:30:03 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.yul.equant.net!news-santiago!helcaraxe.dcc.uchile.cl!guti.no-ip.org!news From: Cristian Gutierrez <crgutier@dcc.uchile.cl> Newsgroups: chile.comp.programacion,chile.comp.pc Subject: Re: SQL: como puedo borrar un registro y todos los valores asociados a el en otras tablas Date: Thu, 22 Apr 2004 00:21:06 -0400 Organization: DCC - Universidad de Chile Lines: 19 Message-ID: <871xmgfxsd.fsf@guti.no-ip.org> References: <c63su8$78c$1@news1.nivel5.cl> <87r7uiufiu.fsf@guti.no-ip.org> <c650e2$krv$1@news1.nivel5.cl> <87n055vqe4.fsf@guti.no-ip.org> <c66lfb$32i$1@news1.nivel5.cl> <c66ptb$32i$3@news1.nivel5.cl> NNTP-Posting-Host: anakena.dcc.uchile.cl Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Trace: helcaraxe.dcc.uchile.cl 1082604844 3768 192.80.24.3 (22 Apr 2004 03:34:04 GMT) X-Complaints-To: newsmaster@dcc.uchile.cl NNTP-Posting-Date: Thu, 22 Apr 2004 03:34:04 +0000 (UTC) Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAFVBMVEWwur7b5OE/XHXBz908 bZlrgIsYIjK7HlDKAAABzElEQVR4nHWUwY6jMAyGXVA444m6ZyYDOVMQ8wBd1HMICucu2+b9H2Fs SFrobq2WqvmIHf+/AfybgJsq2l2onkMT+NoDu4ALzOfx/+Cm9kA+wOuOJILLO/B2xzndg6mMqRZQ A0BKX+eMLTegdiHMAXP1BCd3wGd0KtaQx0/cRlfG4s2J/nIZAEHpUlsGIGhd2KCr9XN3C30YxOOA uKABM3+dAhgRHSdPvC8Qcz9/6xXQ3WYpm9z5qr3zEcgBgdcGvky+8DGVHHLPvQxHw+CqXwFkdwZ/ 9eNUYz4zSBlo/ycAF05FqXISy3sTQHPAZlEr5+K/vO8I9L9J3AKlMyR8BjUI7UcbQJvQgVkmxdJD 2qlLALV1AK1cDQOr+gjaFqJV0xyMCoBvXyKLw9C/jOhjSvqXoW72O05clX7kZgcDYVWl1Rpb0FWk iGBTGlVuasjJ0Cr5keJxXQ+gLpx2/Kmc3YNPylM7AQaafwGnGvBjB/KCgVuK70CrKwsHh7mBaQ8s WOdm5+4k4Q50xdIEjiiyZx+VbE9CGagAKmGaCObznQWvBTVB7qYftwjmaft0ysZHMKAyT1AnoFYH rzQz7L+kSuS4M/SklfySefda+gFsN/KqsKywSQAAAABJRU5ErkJggg== User-Agent: Gnus/5.110002 (No Gnus v0.2) Emacs/21.3 (gnu/linux) Cancel-Lock: sha1:tyWraunwqWCmMi/T+z8rzxZq16Q=