I'm old and forgot how to SQL, so instead of re-learning SQL I just fetch and store individual rows and do everything else in Python. Like an animal.
-
Basically this. Details depend on the data model an your expecatations. E.g. this query does not contain opt_values where not a single row in tags exists. If you prefer "0" in the case, use a LEFT JOIN. Caps => keywords (monochrome syntax highlighting).pic.twitter.com/uRqH6lkWhe
Thanks! That code is working great. 
And I think I even understand why. ;)
Re Caps: But "count" isn't a keyword, is it? I can create a table with that name.
-
-
Re keywords: Anything can be used as identifier, but you might need to put it under double quotes. SQL makes a distinction between reserved and non-reserverd keywords, where non-reserved keywords can be used without double quotes.
-
Interesting. Thanks for the explanation.
- Show replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.