> I think what you want is "CREATE VIEW test.v AS SELECT * FROM t;"
That will do the job, thank you.
--
Richard Heyes
http://www.phpguru.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>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
Good one Ed, simple views are updateable, so that would work
for DML as well.
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
M
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:[EMAIL PROTECTED]
Sent: Friday, August 01, 2008 6:34 AM
To: mysql@lists.mysql.com
Subject: Re: Tabl
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/
No, the net effact would be that the table would have two names.
--
Richard Heyes
http://www.phpguru.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Richard Heyes wrote:
Is there a way in MySQL to define an alias for a table, so in effect
it has two names? For migration purposes.
What exactly do you mean by migration process ?
Do you want to take backup of older tables/databases ?
There are multiple ways of doing the same :
1) use mysq
