List:General Discussion« Previous MessageNext Message »
From:<emierzwa Date:August 1 2008 2:25pm
Subject:RE: Table aliasing
View as plain text  
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

Thread
Table aliasingRichard Heyes1 Aug
  • Re: Table aliasingRanjeet Walunj1 Aug
    • Re: Table aliasingRichard Heyes1 Aug
  • Re: Table aliasingMartijn Tonies1 Aug
    • RE: Table aliasingemierzwa1 Aug
      • Re: Table aliasingRichard Heyes1 Aug
  • Re: Table aliasingMartijn Tonies1 Aug