[SOLVED] select...into error

[dazormiq]

How can I convert the following sql code to working mysql?

 

 

SELECT Employees.Email AS employee_email, Job_Titles.Supervisor AS Supervisor_Title

INTO Supervisors_temp

FROM Job_Titles INNER JOIN Employees ON Job_Titles.Job_Title_ID = Employees.Job_title_ID;

 

I keep getting  "Undeclared variable: Supervisors_temp".  The table exists and gets truncated before the data is put into it.  Currently these tables are stored in an access database being edited through a coldfusion page.  I would love to move to mysql just for the performance boost.

[effigy]

Is this in a function or procedure? If so, declare the variable beforehand:

DECLARE Supervisors_temp VARCHAR(50);

 

[artacus]

INSERT INTO Supervisors_temp

SELECT Employees.Email AS employee_email, Job_Titles.Supervisor AS Supervisor_Title

FROM Job_Titles INNER JOIN Employees ON Job_Titles.Job_Title_ID = Employees.Job_title_ID

[dazormiq]

Putting the insert into in front did it.  Thanks for helping this newbie out.