Oh, but the caveat for this is that the table will be destoyed when the connection is closed. So, if you need this to hang around, you will just need to create another table with this data, or just use that join in your query.
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
