List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 24 1999 4:20pm
Subject:Re: temp tables "#"
View as plain text  
At 10:58 AM -0500 11/24/99, mark@stripped wrote:
>I am using a the newest alpha release (2.23.6) and I  would like to 
>use the new temp table feature. It looks like it is very simmilar to 
>the sybase temp table.
>
>
>So for example, I would like to run the sql below...
>
>
>STA1.AccountID, SS1.StateID, STA1.SIC_ID
>
>INTO #temp
>
>FROM  SIC_TO_ACCOUNTS STA1,
>       STATES_SERVED  SS1
>WHERE
>     STA1.AccountID  =  SS1.AccountID


"#" is not a legal character in a table name in MySQL.
In any case, there seems to be something missing at
the front of your query.

I presume you'll want to use something like this:

CREATE TEMPORARY TABLE temp SELECT
	STA1.AccountID, SS1.StateID, STA1.SIC_ID
FROM  SIC_TO_ACCOUNTS STA1,
	STATES_SERVED  SS1
WHERE
	STA1.AccountID  =  SS1.AccountID

-- 
Paul DuBois, paul@stripped
Thread
temp tables "#"mark24 Nov
  • Re: temp tables "#"Paul DuBois24 Nov
    • Re: temp tables "#"mark24 Nov
      • Re: temp tables "#"Paul DuBois24 Nov
      • Re: temp tables "#"Michael Widenius26 Nov
  • Re: temp tables "#"Steve Ruby24 Nov
Re: temp tables "#"Richard Ellerbrock25 Nov
  • Re: temp tables "#"Paul DuBois25 Nov