Error when inserting data in temporary table (sql)

Question

I am trying to create a temporary table and add information from another table into it. However I keep getting the error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT course_name, ins_name FROM courses where course_name='ACCA'' at line 2'

Can somebody tell me what I am doing wrong?

Here is my code:

INSERT INTO #TempTable (course, ins) 
  SELECT course_name, ins_name
  FROM courses
  where course_name = 'ACCA'

I believe the syntax is SELECT ... INTO #Table FROM ...

AxelH
– AxelH

2016-05-30 11:16:38 +00:00
Commented May 30, 2016 at 11:16 — AxelH
– AxelH, Commented May 30, 2016 at 11:16

ScaisEdge · Accepted Answer · 2016-05-30 11:21:02Z

3

You should create the temp table first

 CREATE TEMPORARY TABLE 
 IF NOT EXISTS your_table  AS (SELECT course_name, ins_name
             FROM courses 
             where course_name='ACCA');

answered May 30, 2016 at 11:21

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

apomene · Accepted Answer · 2016-05-30 11:19:58Z

1

your syntax is fine. However in order to use it you must first create table #TempTable.

More details Here

answered May 30, 2016 at 11:19

apomene

14.4k10 gold badges51 silver badges76 bronze badges

1 Comment

Amani Ben Azzouz Over a year ago

i think in this case the error will be Table doesn't exist

Collectives™ on Stack Overflow

Error when inserting data in temporary table (sql)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related