title: MySQL 8 SELECT statement syntax issue after upgrading from 5.7
body: <p>I have recently started to test MySQL 8 instead of 5.7</p>
  
  <p>Basic SQL select statements fail, that worked correctly in 5.7 and earlier. One such example is:</p>
  
  <p><code>select * from member;</code></p>
  
  <p><em>You have an error in your SQL syntax.... see the manual for usage near 'member'.</em></p>
  
  <p>However, the statement runs fine if you enclose the name of the table you are querying, in this case member, with backticks OR if you prefix the database name to that of the table name, separated with a period.</p>
  
  <p><code>select * from `member`</code> as well as <code>select * from mydbname.member</code> works just fine.</p>
  
  <p>What I want to know is:</p>
  
  <ol>
  <li><p>Is there a sql-mode value, or config file setting one can activate/deactivate this behavior?</p></li>
  <li><p>The mysql online reference examples for SELECT and JOIN syntax is also plain identifiers, such as <code>SELECT * FROM t1 LEFT JOIN (t2, t3, t4) ON (t2.a = t1.a AND t3.b = t1.b AND t4.c = t1.c)</code>. Notice t1 is not enclosed in backticks and the database is also not prefixed.  Am I missing something?</p></li>
  </ol>