table alias (or 'symlink') in mysql
- by andreash
Hi there,
in MySQL5.1, is there a way to make one table accessible by two different names? I'm thinking about somethink like a symlink on linux filesystems.
I know theres the
CREATE VIEW myview AS SELECT * FrOM mytable
thing, but I don't only need to SELECT from both names, but also delete etc ...
You might ask why I want to do this? It's about getting a commercial, closed-source app to work, which is crappily programmed (usually, the table names are all lower-case, but occasionally, they use capitalized names for the same table ...). Oh, that would be another idea: Is there a way to tell MySQL not to care about capitalization of table names (like on Windows filesystems?)? that would also do the trick ...
Thanks for your insight!
A.
