|
From: | Thomas S. Dye |
Subject: | Re: Finally figuring out some ob-sqlite stuff -- for worg? |
Date: | Sat, 09 Nov 2019 07:38:18 -1000 |
User-agent: | mu4e 0.9.18; emacs 26.3 |
Okay, it's up. If anyone wants to explain to me the point of the "where exists" clause in the SQL, I would be interested to hear. It works asexpected this way, but is that clause necessary?
The 'if exists' clause protects against an SQLite error raised if you ask to delete a table that doesn't exist. The code will work without it if the table exists, but will exit without creating the table if not.
Thanks for a useful addition to the Org babel SQLite documentation. I agree with you that Org mode tables are a convenient way to enter SQL data, keeping in mind that table columns can't be rearranged without changes to the SQL code.
All the best, Tom -- Thomas S. Dye http://tsdye.online/tsdye
[Prev in Thread] | Current Thread | [Next in Thread] |