>From the manual: In MySQL Version 3.23, you can use the TEMPORARY keyword...
Sorry, mate, you are SOL until you upgrade -----Original Message----- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:09 PM To: 'MySQL List' Subject: v3.22.32 and temp tables Hi, I want to build a temp table which I can query to sum values. If I try "create temporary table tbl_name select some_query_here", then I get an error that tells me that I have an error with my sql syntax near 'temporary table tbl_name select some_query_here'. Am I correct in thinking that this is due to the version of mysql I'm using? (No, I can't upgrade it at this point). I wasn't successful in finding the answer to my dilemma at www.mysql.com/doc/manual.php. Thanks, Brian --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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