SQL to get received transactions for an address.

[tedtheodorelogan]

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.

[1714807934]

1714807934

[1714807934]

1714807934

[altcoinex]

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

[tedtheodorelogan]

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.