title: How do I create a table alias in MySQL
body: <p>I am migrating an MS Access application (which has linked tables to a MSSQL Server) to MySQL. </p>
  
  <p>As a means to overcome some MSAccess table naming problems, I am seeking a solution to add a MySQL table alias that will point to an existing table in the MySQL database.  Ideally I would like to create the alias 'dbo_customers' in mysql that would point to the customers table also in mysql.  </p>
  
  <p>To be clear I am <em>not</em> wanting to alias a table name inside a query like this:</p>
  
  <pre><code>SELECT * FROM customers AS dbo_customers
  </code></pre>
  
  <p>But rather I would like to be able issue the following query:</p>
  
  <pre><code>SELECT * FROM dbo_customers
  </code></pre>
  
  <p>and have it return data from the customers table. </p>