title: Is the word "AS" in the mysql FROM clause optional?
body: <p>I stumbled across an interesting (to me) query, and I'm not really sure what it does.</p>
  
  <pre><code>SELECT SQL_CALC_FOUND_ROWS DISTINCT P.* FROM table P WHERE P.status = ...
  </code></pre>
  
  <p>The question is in regard to the <code>P</code> specifically <code>FROM table P</code>. I know in the <code>FROM</code> clause you can use an <code>AS</code> clause, but this particular query doesn't. Is the word <code>AS</code> optional? </p>