MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Hiw to fast delete rows from table in relation?
Posted by: Andrzej Borucki
Date: January 22, 2017 04:03AM

first:
delete from bitcoin.transactions_detail where tx_hash in (select tx_hash from bitcoin.transactions_general where block_height=449319)
next:
delete from bitcoin.transactions_general where block_height=449319

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Hiw to fast delete rows from table in relation?
1216
Andrzej Borucki
January 22, 2017 02:21AM
Re: Hiw to fast delete rows from table in relation?
688
Andrzej Borucki
January 22, 2017 03:39AM
Re: Hiw to fast delete rows from table in relation?
621
Andrzej Borucki
January 22, 2017 04:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.