Table aliasing

2008-08-01 Thread Richard Heyes
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

Re: Table aliasing

2008-08-01 Thread Ranjeet Walunj
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

Re: Table aliasing

2008-08-01 Thread Richard Heyes
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]

Re: SET vs. ENUM

2008-08-01 Thread Martijn Tonies
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

Replication error 1236

2008-08-01 Thread Olaf Stein
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

Re: Table aliasing

2008-08-01 Thread Martijn Tonies
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:

RE: Table aliasing

2008-08-01 Thread emierzwa
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

Re: Table aliasing

2008-08-01 Thread Martijn Tonies
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

Re: Table aliasing

2008-08-01 Thread Richard Heyes
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]

Re: Lookup tables

2008-08-01 Thread Rudolf Lippan
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

Re: Lookup tables

2008-08-01 Thread Perrin Harkins
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