Article View: pl.comp.bazy-danych
Article #195207Re: [MySQL] Jak usuwać wiersze z tabeli w relacji?
From: Borneq
Date: Sun, 22 Jan 2017 10:02
Date: Sun, 22 Jan 2017 10:02
10 lines
1428 bytes
1428 bytes
W dniu 22.01.2017 o 09:03, Borneq pisze: > delete from detail where hash = select hash from general where kod=:kod delete from bitcoin.transactions_detail where tx_hash in (select tx_hash from bitcoin.transactions_general where block_height=449319) a POTEM, nie można przedtem delete from bitcoin.transactions_general where block_height=449319 Trzeba było zmienić aby nie było safe mode, dość szybko usunęło 800 wierszy ale tabele były dość pustawe.
Technical Details
Message-ID:
<o61vvj$e2f$1@node2.news.atman.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!.POSTED!not-for-mailReferences:
<o608pm$rug$1@node1.news.atman.pl> <1jm0hb94bbqu5.dlg@tyczka.com> <o61ovp$7ib$1@node2.news.atman.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.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 11:02:26 +0100 Organization: ATMAN - ATM S.A. Lines: 10 Message-ID: <o61vvj$e2f$1@node2.news.atman.pl> References: <o608pm$rug$1@node1.news.atman.pl> <1jm0hb94bbqu5.dlg@tyczka.com> <o61ovp$7ib$1@node2.news.atman.pl> NNTP-Posting-Host: 91.239.205.105 Mime-Version: 1.0 X-Trace: node2.news.atman.pl 1485079347 14415 91.239.205.105 (22 Jan 2017 10:02:27 GMT) X-Complaints-To: usenet@atman.pl NNTP-Posting-Date: Sun, 22 Jan 2017 10:02:27 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Thunderbird/45.6.0 In-Reply-To: <o61ovp$7ib$1@node2.news.atman.pl> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit