• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

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)
0
willsherwood
Asked:
willsherwood
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
I think the only thing you can do is copy the tables and rename the columns.
0
 
willsherwoodAuthor Commented:
thanks - saves me further time stewing over it!
0

Featured Post

Hire Technology Freelancers with Gigs

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now