Difference between revisions of "gnucash mysql invoice query"

From thelinuxwiki
Jump to: navigation, search
(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)