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 another question is, I looked up CREATE TEMPORARY TABLE | What I want to know is can I do the following: | | create temporary table (select [distinct] jump.name, jump.address, | bike.city, bike.state, skate.zipcode, skate.car, skate.name, skate.city | from jump, bike inner join skate on jump.name=skate.name where | bike.city=skate.city and jump.name=skate.name and (skate.car>0) | order by skate.name; | ????? | This is the type of query that I have to excute to create the temp table. The client wants much info combined into one table. Thanks. | If anyone has any other ideas I'm listening!! | | THANKS for all your help and suggestions. | --Lupita | | "Brian Moon" <[EMAIL PROTECTED]> wrote: | | >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...... | > | > | >| 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 do this in Oracle all the time. BEEP! wrong thought. | >The docs say, no can do especially with TEXT or BLOB datatypes. Does anyone | >have any ideas on what I can do? The client needs a temp table to be created | >with data from 3 different tables for info purposes. They just want to do a | >select on the table to see what they want to see. | >| All help will be welcome. Thank you all in advance....Lupita | >| | >| | >| __________________________________________________________________ | >| Your favorite stores, helpful shopping tools and great gift ideas. | >Experience the convenience of buying online with Shop@Netscape! | >http://shopnow.netscape.com/ | >| | >| Get your own FREE, personal Netscape Mail account today at | >http://webmail.netscape.com/ | >| | >| | >| --------------------------------------------------------------------- | >| Before posting, please check: | >| http://www.mysql.com/manual.php (the manual) | >| http://lists.mysql.com/ (the list archive) | >| | >| To request this thread, e-mail <[EMAIL PROTECTED]> | >| To unsubscribe, e-mail | ><[EMAIL PROTECTED]> | >| Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php | >| | >| | > | > | | | __________________________________________________________________ | Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ | | Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ | | --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
