mysql 5.1 (or later) - is it possible to define IN THE DATABASE DEFINITION alternate names for tables and fields
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)
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.