Difference between revisions of "gnucash mysql invoice query"
From thelinuxwiki
(Created page with " == CLI queries for gnucash invoice data == '''get invoice guid''' mysql> SELECT guid FROM gnucash_netsolve_2013.invoices WHERE id = "2013018"; +---------------------------...") |
(→CLI queries for gnucash invoice data) |
||
Line 3: | Line 3: | ||
'''get invoice guid''' | '''get invoice guid''' | ||
− | mysql> SELECT guid FROM gnucash_netsolve_2013.invoices WHERE id = "2013018"; | + | mysql> '''SELECT guid FROM gnucash_netsolve_2013.invoices WHERE id = "2013018";''' |
+----------------------------------+ | +----------------------------------+ | ||
| guid | | | guid | |
Revision as of 13:51, 24 May 2013
CLI queries for gnucash invoice data
get invoice guid
mysql> SELECT guid FROM gnucash_netsolve_2013.invoices WHERE id = "2013018"; +----------------------------------+ | guid | +----------------------------------+ | f32b43b6da2b19e4e9e838d30ffc1edb | +----------------------------------+ 1 row in set (0.00 sec)