Bitcoin Forum
November 20, 2018, 10:50:15 PM *
News: Latest Bitcoin Core release: 0.17.0 [Torrent].
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: SQL to get received transactions for an address.  (Read 1362 times)
tedtheodorelogan
Newbie
*
Offline Offline

Activity: 18
Merit: 0


View Profile
February 22, 2015, 07:14:03 PM
 #1

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.
1542754215
Hero Member
*
Offline Offline

Posts: 1542754215

View Profile Personal Message (Offline)

Ignore
1542754215
Reply with quote  #2

1542754215
Report to moderator
1542754215
Hero Member
*
Offline Offline

Posts: 1542754215

View Profile Personal Message (Offline)

Ignore
1542754215
Reply with quote  #2

1542754215
Report to moderator
1542754215
Hero Member
*
Offline Offline

Posts: 1542754215

View Profile Personal Message (Offline)

Ignore
1542754215
Reply with quote  #2

1542754215
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
altcoinex
Sr. Member
****
Offline Offline

Activity: 293
Merit: 250


Director - www.cubeform.io


View Profile WWW
February 23, 2015, 03:42:12 AM
 #2

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


                                     ╓╢╬╣╣╖
                                   ┌║██████║∩
                                   ]█████████
                                    ╜██████╝`
                                      ╙╜╜╜`
                                   ╓╥@@@@@@╥╓
         ╓╖@@╖,                 ,@║██████████╢@,                 ,╓@@╖╓
       ╓╢██████╢.              ╓╢███████████████╖               ║╢█████║╓
       ║█████████    ,,╓╓,,   ┌║█████████████████┐   ,,╓╓,,    ]█████████
       └╢██████║` ╓╢║██████╢║∩``╙╙╙╙╙╙╙╙╙╙╙╙╙╙╙╙╙`»╢╢██████╢║╖  ║███████╜
         "╜╜╜╜` ╖╢█████████╣╜                      └╢██████████@ `╜╜╜╜╜
               ║██████████╜                          ╙╢██████████
              ┌█████████╜                              ╙╢█████████
              └███████╨`                                 ╜████████
               ║████╨╜                                    `╢█████
                ╙╢╣╜                                        └╢█╜
                ,,                                            ,,
             ╓@║██┐                                          ┌██║@╓
            ╢██████                                          ]█████H
           ╢███████∩                                        ┌████████
  ╓@@@@╓   █████████                                        ║████████`  ╓@@@@╖
╓╢██████║. █████████∩                                      ┌█████████ ,║███████╖
██████████ └█████████                                      ██████████ ]█████████
`║██████╜`  └╢████████                                    ┌███████╣╜   ╙██████╨`
  `╙╜╜╙`      `╙╨╢████                                    █████╝╜`       `╙╜╜`
                      ]@╓                              ╓╖H
                      ███╢║@╓,                    ,╓@╢╢███`
                      ████████╢@╖╓.           ╓╖@║████████`
                      ]███████████╢║@╓,  ,╓@╢╢████████████
                       ╙╢█████████████╨` ╜██████████████╜
                         ╙╝╢███████║╜`    `╜║████████╝╜`
                     ,╓@@@╓  `²╙``             `╙²`  ╓@@@╖,
                    ║╢█████╢H                      ╓╢██████H
                    █████████                      █████████`
                    ╙╢██████╜                      ╙╢██████╜
                      └╨╩╝┘                          └╨╩╝╜
WINFLOW.
██
██
██
██
██
██
██
██
██
██
██
██
██
..
██
██
██
██
██
██
██
██
██
██
██
██
██
.
tedtheodorelogan
Newbie
*
Offline Offline

Activity: 18
Merit: 0


View Profile
February 23, 2015, 06:37:36 AM
 #3

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.
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!