MySQL AS keyword

by

I’m not professional in query writing, but wrote many from the time I began MySQL. Recently I noticed there is no need to type AS keyword in name aliasing.

SELECT name AS n

equals to

SELECT name n

However I know that this ability is out from years ago. I’ve 2 questions around this subject:

  1. Is AS keyword redundant?
  2. Sometimes ago when I encountered with a custom query on a website with having no AS in aliasing, that its executing made MySQL service down, I changed the way of name aliasing with adding AS keyword and this little change made it work! What was the problem here?

Leave a Comment