3 ms·
> God is merciful because AND_ is 4 characters, a good tab width, so WHERE conditions are to be lined up like (same for JOIN conditions) WHERE coun
by jolmg 7y ago
> God is merciful because AND_ is 4 characters, a good tab width, so WHERE conditions are to be lined up like (same for JOIN conditions)
WHERE
country = 'UAE'
AND day >= DATE('2019-07-01')
AND DAY_OF_WEEK(day) != 5
AND scheduled_accuracy_meters <= 10*1000
It looks better when you use a tab-width of 2:
WHERE country = 'UAE'
AND day >= DATE('2019-07-01')
AND DAY_OF_WEEK(day) != 5
AND scheduled_accuracy_meters <= 10*1000
- philshem 7y agoI don’t know if this will go over well, but how about the infamous 1=1? WHERE 1=1 AND country = 'UAE' AND day >= DATE('2019-07-01') AND DAY_OF_WEEK(day) != 5 AND scheduled_accuracy_meters <= 10*1000 (More reading: https://stackoverflow.com/q/242822 https://stackoverflow.com/q/242822)
- CraftThatBlock 7y agoWHERE TRUE would also work, so would WHERE 1 I believe