I think what you want is "CREATE VIEW test.v AS SELECT * FROM t;"
http://dev.mysql.com/doc/refman/5.0/en/create-view.html
Ed
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@stripped]
Sent: Friday, August 01, 2008 6:34 AM
To: mysql@stripped
Subject: Re: Table aliasing
Hello Richard,
> Is there a way in MySQL to define an alias for a table, so in effect
> it has two names? For migration purposes.
No, it does not support aliasses.
But I think you could use the "merge storage engine" to do pretty
much the same, have a look here:
http://dev.mysql.com/doc/refman/5.1/en/merge-storage-engine.html
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
