v3.22.32 and temp tables

2002-02-19 Thread Brian Warn
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

RE: v3.22.32 and temp tables

2002-02-19 Thread Rick Emery
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