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

willsherwood
willsherwood used Ask the Experts™
on
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)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Fixer of Problems
Most Valuable Expert 2014
Commented:
I think the only thing you can do is copy the tables and rename the columns.

Author

Commented:
thanks - saves me further time stewing over it!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial