Gneale: Created page with "===== Return to: Chialisp ===== Useful Commands:

cd ~/.chia/mainnet/db

sqlite3 blockchain_v2_testnet10.sqlite

SELECT hex(hint),hex(coin_id) FROM hints LIMIT 1000,100;

SELECT * FROM hints where coin_id = X'02AD7C44D75DE72550B2A8A6E63652C993AC9A60C641AE644230230D95EAD315';

SELECT * FROM hints WHERE hint = X'01388426758A92EFA9669821578216A223FF167154CFCF67F5E6E8DD76DAF05E'

SELECT * FROM hint..."

2023-11-17T15:58:55Z

Created page with "===== Return to: Chialisp ===== <big>Useful Commands:</big> <pre>cd ~/.chia/mainnet/db</pre> <pre>sqlite3 blockchain_v2_testnet10.sqlite</pre> <pre>SELECT hex(hint),hex(coin_id) FROM hints LIMIT 1000,100;</pre> <pre>SELECT * FROM hints where coin_id = X'02AD7C44D75DE72550B2A8A6E63652C993AC9A60C641AE644230230D95EAD315';</pre> <pre>SELECT * FROM hints WHERE hint = X'01388426758A92EFA9669821578216A223FF167154CFCF67F5E6E8DD76DAF05E'</pre> <pre>SELECT * FROM hint..."

New page

===== Return to: [[Chialisp|Chialisp]] =====
<big>Useful Commands:</big>
<pre>cd ~/.chia/mainnet/db</pre>
<pre>sqlite3 blockchain_v2_testnet10.sqlite</pre>
<pre>SELECT hex(hint),hex(coin_id) FROM hints LIMIT 1000,100;</pre>
<pre>SELECT * FROM hints where coin_id = X'02AD7C44D75DE72550B2A8A6E63652C993AC9A60C641AE644230230D95EAD315';</pre>
<pre>SELECT * FROM hints WHERE hint = X'01388426758A92EFA9669821578216A223FF167154CFCF67F5E6E8DD76DAF05E'</pre>
<pre>SELECT * FROM hints where hex(coin_id) = "02AD7C44D75DE72550B2A8A6E63652C993AC9A60C641AE644230230D95EAD315";</pre>
<pre>SELECT hex(hint) FROM hints LIMIT 1000,10;</pre>
<pre>SELECT hex(hint),hex(coin_id) FROM hints WHERE hint = X'01388426758A92EFA9669821578216A223FF167154CFCF67F5E6E8DD76DAF05E';</pre>

Hinting - Revision history