title: MySQL AS keyword
body: <p>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 <code>AS</code> keyword in name aliasing.</p>
  
  <pre><code>SELECT name AS n
  </code></pre>
  
  <p>equals to </p>
  
  <pre><code>SELECT name n
  </code></pre>
  
  <p>However I know that this ability is out from years ago. I've 2 questions around this subject:</p>
  
  <ol>
  <li>Is <code>AS</code> keyword redundant?</li>
  <li><p>Sometimes ago when I encountered with a custom query on a website with having no <code>AS</code> in aliasing, that its executing made MySQL service down, I changed the way of name aliasing with adding <code>AS</code> keyword and this little change made it work!</p>
  
  <p>What was the problem here?</p></li>
  </ol>