Hi,
Is there a way in MySQL to define an alias for a table, so in effect
it has two names? For migration purposes.
Thanks.
--
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
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
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]
Hello Jerry and Martijn
sets contains an iterator so you can iterate thru the objects
also supports the contains method set.contains(new String(foo))
http://www.docjar.com/docs/api/java/util/Set.html
Enums must use the exact index and are generally use for fixed constant
Array
Hi All,
Once a week or so I get the following error:
080801 8:18:35 [ERROR] Error reading packet from server: error reading log
entry ( server_errno=1236)
080801 8:18:35 [ERROR] Got fatal error 1236: 'error reading log entry' from
master when reading data from binary log
Stopping the slave
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:
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: Table aliasing
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
MS SQL
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]
On Thu, 31 Jul 2008 13:57:07 -0400, Perrin Harkins [EMAIL PROTECTED]
wrote:
On Thu, Jul 31, 2008 at 12:59 PM, Chris W [EMAIL PROTECTED] wrote:
So my question is, is doing that way better than making the query more
complex with all the joins?
If by better you mean faster then yes, it
On Fri, Aug 1, 2008 at 7:32 AM, Rudolf Lippan [EMAIL PROTECTED] wrote:
How would you get duplicated data? In one case you have an integer
and in the other you have the value, but you still have to store one token
of information with the row.
I meant in the case of storing the value
11 matches
Mail list logo