|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: View onto tables w/ identical key names
From: Martijn Tonies (m.tonies
upscene.com)
Date: Fri Jul 01 2005 - 09:43:09 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> >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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]