Is there a way of setting an alias to a column name when you create the table or by using the "alter" command.
My problem is i have 2 versions of the same table with one column having a slightly different name (e.g old column name is id, new column name is a_id). Now, to save having to amend (& test) 20 or so scripts running off the old version, i would like to set an alias against "a_id" so it is aliased as "id". therefore both old & new code will be able to run off the same (new) table version.
If i could do the above it would mean i could amend the older scripts to run on the newer version code over a period of time.
Any ideas ??
Regards
Sean
_________________________________________________________________
Get MSN 8 Dial-up Internet Service FREE for one month. Limited time offer-- sign up now! http://join.msn.com/?page=dept/dialup
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]