Article View: pl.comp.bazy-danych
Article #195206Re: [MySQL] Jak usuwać wiersze z tabeli w relacji?
From: Borneq
Date: Sun, 22 Jan 2017 08:03
Date: Sun, 22 Jan 2017 08:03
18 lines
1370 bytes
1370 bytes
W dniu 21.01.2017 o 21:59, Roman Tyczka pisze: > On Sat, 21 Jan 2017 19:20:38 +0100, Borneq wrote: > >> z general chcemy usuwać wszystkie wiersze dla zadanego kodu: >> delete from general where kod=:kod > trigger A bez triggera jako polecenie SQL? Like delete from detail where hash = select hash from general where kod=:kod ? delete from detail left join general on detail.hash=general.hash where general.kod = :kod ?
Technical Details
Message-ID:
<o61ovp$7ib$1@node2.news.atman.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mailReferences:
<o608pm$rug$1@node1.news.atman.pl> <1jm0hb94bbqu5.dlg@tyczka.com>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!.POSTED!not-for-mail From: Borneq <borneq@antyspam.hidden.pl> Newsgroups: pl.comp.bazy-danych Subject: Re: [MySQL] Jak usuwać wiersze z tabeli w relacji? Date: Sun, 22 Jan 2017 09:03:06 +0100 Organization: ATMAN - ATM S.A. Lines: 18 Message-ID: <o61ovp$7ib$1@node2.news.atman.pl> References: <o608pm$rug$1@node1.news.atman.pl> <1jm0hb94bbqu5.dlg@tyczka.com> NNTP-Posting-Host: 91.239.205.105 Mime-Version: 1.0 X-Trace: node2.news.atman.pl 1485072185 7755 91.239.205.105 (22 Jan 2017 08:03:05 GMT) X-Complaints-To: usenet@atman.pl NNTP-Posting-Date: Sun, 22 Jan 2017 08:03:05 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.6.0 In-Reply-To: <1jm0hb94bbqu5.dlg@tyczka.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit