I have a problem similar to Alias Column Names at the Database Level [MySQL]
It was in 2013, may be status as changed in 2015 so I am asking again :)
I got a table with auto generated names for columns that can be a bit long and with '.' and '^' chars in there, the number of columns this way can be high.
This is ok, I can always quote this later in queries.
Ex: select 'a.c.d^e.f' from t
Now for popular request, i.e columns used very often, I'd like to be able to setup an alias name, I fear the answer is NO , yet asking :)
Dreaming about creating an aditional column afterward like this
alter table t alias [column] 'a.c.d^e.f' to F
I could then issue: select F from t; Would be short no quote etc...
Thanx in advance Phi
Aucun commentaire:
Enregistrer un commentaire