Why do you need to place columns you create yourself (for example select 1 as "number"
) after HAVING
and not WHERE
in MySQL?
And are there any downsides instead of doing WHERE 1
(writing the whole definition instead of a column name)?
Why do you need to place columns you create yourself (for example select 1 as "number"
) after HAVING
and not WHERE
in MySQL?
And are there any downsides instead of doing WHERE 1
(writing the whole definition instead of a column name)?