From: Martijn Tonies
Date: July 1 2005 2:43pm
Subject: Re: View onto tables w/ identical key names
List-Archive: http://lists.mysql.com/mysql/186156
Message-Id: <00e001c57e4b$333a4170$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit



> >When creating the view, use
> >CREATE VIEW viewname ( column names )
> >AS
> >select [fields]
> >
> >Instead of "*". This way, you can only return a single "mat" column
instead
> >of having that column twice in the view.
> >
>
>
> i'll try that programmatically, no way am i typing close to 1000 field
> names into the query browser   ;-)

Get yourself a GUI tool with which you can simply drag if a list of fields
:-)

I know one ... Database Workbench - www.upscene.com ;-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com