4 ms·
I write my SQL as follows: SELECT `second_column`, `fourth_column` FROM `table_name` WHERE `first_column` = 'Value' AND `third
by Revell 10y ago
I write my SQL as follows:
SELECT `second_column`,
`fourth_column`
FROM `table_name`
WHERE `first_column` = 'Value'
AND `third_column` = 3
ORDER BY `fifth_column` ASC
LIMIT 1
- 83457 10y agoWell that is cute. I find it odd that the second line of the where clause is on the same level as the where but a neat format otherwise. Tabs or spaces though?
- dfox 10y agoWhat happens when you need to do something non-trivial? Ie. nested selects, joins or even only some more complex expression in WHERE?