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.
-
But that’s no big issue—bulky but not disastrous. Upper case tells the database that it is urgent ;)
So maybe I should be using uppercase COUNT here to, you know, speed it up a bit.. :Dpic.twitter.com/zesABoljv5
-
-
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. - 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.