I read (if I remember correctly in a post or a comment to a question on Stackoverflow in English) in SQL does not use
AS for aliases was a bad practice.
I usually use my query without a
AS when you are alias, because it seems to me more elegant, for example:
SELECT COUNT(*) total FROM tabla t1 INNER JOIN tabla2 t2 ON t1.id=t2.id; SELECT MAX(id) mayor FROM tabla ...
SELECT COUNT(*) AS total FROM tabla AS t1 INNER JOIN tabla2 AS t2 ON t1.id=t2.id; SELECT MAX(id) AS mayor FROM tabla ...
I was looking for example in the MySQL Reference Manual and found nothing that says explicitly not to use
AS it's a bad practice.
In summary, I want to know if you don't use
AS is a bad practice. If it is, why it is and where it is documented?
The question refers to SQL in general, not to specific handlers.