MySQL INSERT - SELECT syntax problem!

Question

INSERT IGNORE INTO table3
(id1,   id2) VALUES
SELECT id1, id2 FROM table1, table2;

What's wrong with the above SQL query?

It shows me syntax error.

D'Arcy Rittich · Accepted Answer · 2010-08-12 14:37:41Z

5

Remove the word VALUES. See here for spec:

INSERT IGNORE INTO table3
(id1,   id2) 
SELECT id1, id2 FROM table1, table2;

And note Russ' response.

answered Aug 12, 2010 at 14:37

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

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

3 Comments

Thanks a lot. Unfortunately i did not care about it. :(

@Saiful: what is this it that you refer to?

can't they relax this rule, made me go mad

Russ · Accepted Answer · 2010-08-12 14:37:54Z

2

Remove "VALUES".

Oh, and by the way, you've got a cartesian join. You should add syntax to join table1 to table2.

answered Aug 12, 2010 at 14:37

Russ

4,19324 silver badges33 bronze badges

+1 for catching the cartesian join. That could cause a lot of pain... unless OP actually wants that...

SQLMenace · Accepted Answer · 2010-08-12 14:38:43Z

0

try this

INSERT IGNORE INTO table3(id1,   id2) 
SELECT id1, id2 FROM table1, table2;

VALUES is not used in combination with a SELECT statement

answered Aug 12, 2010 at 14:38

SQLMenace

136k25 gold badges212 silver badges227 bronze badges