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 di

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" the

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: 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 & M

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 He

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: http://dev.mysql.com/doc/refman/

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 an

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

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: 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 mysq

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 PRO