<div>
thanks - saves me further time stewing over it!
</div>


<div>
<div class="content wysiwyg-content">
we have an inherited db that is being migrated in several phases.<br />
it would be best to define a set of synonyms (aliases) so that the new names could be used in new queries/scripts<br />
and then eventually usage of the old (awful conventions were used) &nbsp;would be phased out.<br />
<br />
is there a DEFINE (old_table_name, new_table_name) &nbsp; &nbsp;feature somewhere?<br />
<br />
i think the answer is no (i've not been able to find anything)
</div>
</div>


we have an inherited db that is being migrated in several phases.
it would be best to define a set of synonyms (aliases) so that the new names could be used in new queries/scripts
and then eventually usage of the old (awful conventions were used)  would be phased out.

is there a DEFINE (old_table_name, new_table_name)    feature somewhere?

i think the answer is no (i've not been able to find anything)

mysql  5.1 (or later) - is it possible to define IN THE DATABASE DEFINITION alternate names for tables and fields

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.