Bitcoin Forum

Bitcoin => Bitcoin Technical Support => Topic started by: tedtheodorelogan on February 22, 2015, 07:14:03 PM

Title: SQL to get received transactions for an address.
Post by: tedtheodorelogan on February 22, 2015, 07:14:03 PM

Can anyone give me any pointers on the SQL query to pull received transactions from abe MySQL please? Really struggling to find any info on table / relationship structure.

Title: Re: SQL to get received transactions for an address.
Post by: altcoinex on February 23, 2015, 03:42:12 AM

You may need to be more specific to get the answer your looking for, but if you mean all received transactions, then

Code:

SELECT * FROM txin

Although I assume you mean something likely more specific, but you will need to elaborate on what your actually trying to retrieve....

Perhaps this will be of use: http://bitcoin.stackexchange.com/questions/19019/meaning-of-the-tables-in-the-blockchain-database

Title: Re: SQL to get received transactions for an address.
Post by: tedtheodorelogan on February 23, 2015, 06:37:36 AM

Thanks altcoinex. I was hoping to get transactions in from a specific address. I know I need the public has to get this. I can get that from a wallet address ok now, but still struggling to return received transactions.