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
