Re: MySQL and creating views......

2002-08-20 Thread Brian Moon
gt; To: ""Brian Moon"" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 12:51 PM Subject: Re: MySQL and creating views.. | Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE | What I want to know is can I do the followi

Re: MySQL and creating views......

2002-08-20 Thread Brian Moon
That should work just fine. Brian. - Original Message - From: <[EMAIL PROTECTED]> To: ""Brian Moon"" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 12:51 PM Subject: Re: MySQL and creating views.. | Thanks Brian. But a

Re: MySQL and creating views......

2002-08-20 Thread lupita220
-- >From: <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, August 20, 2002 11:44 AM >Subject: MySQL and creating views.. > > >| I am new to this group. I am part of a small website dev shop and we just >started using MySQL. I was tasked with the foll

Re: MySQL and creating views......

2002-08-20 Thread Brian Moon
Do you need to create a temp table or a heap table? Temp tables support those columns fine. Heap tables do not. Brian. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 20, 2002 11:44 AM Subject: MySQL and creating views.. |

MySQL and creating views......

2002-08-20 Thread lupita220
I am new to this group. I am part of a small website dev shop and we just started using MySQL. I was tasked with the following: Write a perl script(did this part) to open up the MySQL database and create a View (a temp table) from 3 different tables. I thought no problem I know how to do this I