API tools faq
paste
Borneq

select_tx

Borneq
Aug 1st, 2017
502
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.17 KB | None | 0 0
raw download clone embed print report
  1. mysql> SELECT * FROM transactions LIMIT 10;
  2. +--------------+---------------------+-----------+------------------------------------------+------------------------------------------+--------------------------------------------------+------+---------+-----------+----------------+-------+----------------------+------------+-----------+-----------+-----------+--------------+-------+-----------+--------------+-------+
  3. | block_height | block_time          | condition | from_adr                                 | to_adr                                   | tx_hash                                          | TYPE | indx_tx | subtraces | trace_adr_hash | VALUE | gas_limit1           | gas_limit2 | gas_price | gas_used1 | gas_used2 | cum_gas_used | nonce | call_type | contract_adr | error |
  4. +--------------+---------------------+-----------+------------------------------------------+------------------------------------------+--------------------------------------------------+------+---------+-----------+----------------+-------+----------------------+------------+-----------+-----------+-----------+--------------+-------+-----------+--------------+-------+
  5. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 000d836201318ec6899a67540690382780743280 | GENESIS_000d836201318ec6899a67540690382780743280 |    0 |       6 |      4702 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  6. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 001762430ea9c3a26e5749afdb70da5f78ddbb8c | GENESIS_001762430ea9c3a26e5749afdb70da5f78ddbb8c |    0 |       6 |      3596 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  7. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 001d14804b399c6ef80e64576f657660804fec0b | GENESIS_001d14804b399c6ef80e64576f657660804fec0b |    0 |       6 |      8097 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  8. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 0032403587947b9f15622a68d104d54d33dbd1cd | GENESIS_0032403587947b9f15622a68d104d54d33dbd1cd |    0 |       6 |      7502 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  9. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 00497e92cdc0e0b963d752b2296acb87da828b24 | GENESIS_00497e92cdc0e0b963d752b2296acb87da828b24 |    0 |       6 |      5335 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  10. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 004bfbe1546bc6c65b5c7eaa55304b38bbfec6d3 | GENESIS_004bfbe1546bc6c65b5c7eaa55304b38bbfec6d3 |    0 |       6 |      2329 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  11. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 005a9c03f69d17d66cbb8ad721008a9ebbb836fb | GENESIS_005a9c03f69d17d66cbb8ad721008a9ebbb836fb |    0 |       6 |       760 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  12. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 005d0ee8155ec0a6ff6808552ca5f16bb5be323a | GENESIS_005d0ee8155ec0a6ff6808552ca5f16bb5be323a |    0 |       6 |      4660 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  13. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 007622d84a234bb8b078230fcf84b67ae9a8acae | GENESIS_007622d84a234bb8b078230fcf84b67ae9a8acae |    0 |       6 |      5811 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  14. |            0 | 2015-07-30 15:26:13 |         0 | 000000000000000000000000000000000GENESIS | 007b9fc31905b4994b04c9e2cfdc5e2770503f42 | GENESIS_007b9fc31905b4994b04c9e2cfdc5e2770503f42 |    0 |       6 |      3743 | 0              |     6 | 18446744073709551615 |          0 |         0 |         0 |         0 |            0 |     0 | 0x        | NULL         | NULL  |
  15. +--------------+---------------------+-----------+------------------------------------------+------------------------------------------+--------------------------------------------------+------+---------+-----------+----------------+-------+----------------------+------------+-----------+-----------+-----------+--------------+-------+-----------+--------------+-------+
  16. 10 ROWS IN SET (0,00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!