Re: Tables "shortcuts"?

2004-12-23 Thread Nico Alberti
On Thu, 23 Dec 2004 11:54:30 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Yes, it should be possible to 'alias' an entire table through a view Thank you all for your help. Of course the production server is 4.1, but I will start immediately to test version 5 -- Ciao Nico -- MySQL G

Re: Tables "shortcuts"?

2004-12-23 Thread Nico Alberti
On Thu, 23 Dec 2004 11:30:34 -0500, Rhino <[EMAIL PROTECTED]> wrote: > > It is always best if you post followup questions/remarks back to the list. Sorry, wrong button. -- Ciao Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: Tables "shortcuts"?

2004-12-23 Thread SGreen
based on a Join is ALWAYS read-only. > > Rhino > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "Rhino" <[EMAIL PROTECTED]> > Cc: "mysql" ; "Nico Alberti" <[EMAIL PROTECTED]> > Sent: Thursday, December 23, 2004 11:

Re: Tables "shortcuts"?

2004-12-23 Thread Rhino
]> Sent: Thursday, December 23, 2004 11:54 AM Subject: Re: Tables "shortcuts"? > Yes, it should be possible to 'alias' an entire table through a view > (assuming your version of MySQL has views). Views will be "updateable" so > long as none of the columns

Re: Tables "shortcuts"?

2004-12-23 Thread SGreen
you. Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Rhino" <[EMAIL PROTECTED]> wrote on 12/23/2004 11:30:34 AM: > > - Original Message - > From: "Nico Alberti" <[EMAIL PROTECTED]> > To: "Rhino" <[EMAIL PROTECTED]

Re: Tables "shortcuts"?

2004-12-23 Thread Rhino
- Original Message - From: "Nico Alberti" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Sent: Thursday, December 23, 2004 10:25 AM Subject: Re: Tables "shortcuts"? > On Thu, 23 Dec 2004 08:46:13 -0500, Rhino <[EMAIL PROTECTED]&g

Tables "shortcuts"?

2004-12-23 Thread Nico Alberti
Hi everybody. I am rather new to MySQL (and to dba in general), so sorry for the lame question (and for my English). Our company is migrating several Access database to MySQL by now with good results. This process sometimes brings to a reorganization of some key tables that are used by many appli