Article View: pl.comp.bazy-danych
Article #195208Re: [MySQL] Jak usuwać wiersze z tabeli w relacji?
From: geos
Date: Sun, 22 Jan 2017 09:20
Date: Sun, 22 Jan 2017 09:20
14 lines
1381 bytes
1381 bytes
On 21.01.2017 19:20, Borneq wrote: > hash = primary key > detail: > hash+index = primary key > delete from general where kod=:kod > teraz chcemy usunąć wszystkie wiersze z detail których hash jest równy > usuwanym haszom > Jak to zrobić? Select we Where czy Join ? http://www.mysqltutorial.org/mysql-on-delete-cascade/
Technical Details
Message-ID:
<58847957$0$652$65785112@news.neostrada.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin1!goblin.stu.neva.ru!peer01.fr7!futter-mich.highwinds-media.com!news.highwinds-media.com!newsfeed.neostrada.pl!unt-exc-02.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mailReferences:
<o608pm$rug$1@node1.news.atman.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin1!goblin.stu.neva.ru!peer01.fr7!futter-mich.highwinds-media.com!news.highwinds-media.com!newsfeed.neostrada.pl!unt-exc-02.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mail Subject: Re: [MySQL] Jak usuwać wiersze z tabeli w relacji? Newsgroups: pl.comp.bazy-danych References: <o608pm$rug$1@node1.news.atman.pl> From: geos <geos@SPAMPRECZ.autograf.pl> Date: Sun, 22 Jan 2017 10:20:21 +0100 MIME-Version: 1.0 In-Reply-To: <o608pm$rug$1@node1.news.atman.pl> Lines: 14 Message-ID: <58847957$0$652$65785112@news.neostrada.pl> Organization: Telekomunikacja Polska NNTP-Posting-Host: 095160100165.warszawa.vectranet.pl X-Trace: 1485076823 unt-rea-b-01.news.neostrada.pl 652 95.160.100.165:49434 X-Complaints-To: abuse@news.neostrada.pl X-Received-Bytes: 1153 X-Received-Body-CRC: 4077354049 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit