OSEC

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: Les Schaffer (schafferoptonline.net)
Date: Fri Jul 01 2005 - 09:32:22 CDT

Martijn Tonies wrote:

>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 ;-)

thanks

les schaffer

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql