SQL Syntax Error - INSERT INTO ... SELECT

Question

When I run this statement within MySQL Workbench, I get a syntax error near the SELECT statement.

INSERT INTO 
    rare_csshop.cscart_product_features_values
        (feature_id, product_id, value, lang_code)
VALUES
    SELECT DISTINCT
    "10" As Feature, t1.product_id, CONCAT(t2.NHeigth, "\" H x ", t2.NWidth, "\" W x ", t2.NDepth, "\" D") As Dimensions, "EN" As Lang
FROM
    rare_csshop.cscart_product_descriptions AS t1, 
    rare_csshop.products AS t2
WHERE
    t1.product = t2.NName

The select statement runs fine on it's own. Am I missing something?

Bill the Lizard · Accepted Answer · 2011-11-02 22:02:25Z

5

You need to remove the word VALUES from your query (you insert either values, OR a SELECT result).

edited Nov 2, 2011 at 22:02

Bill the Lizard

407k213 gold badges579 silver badges892 bronze badges

answered Nov 2, 2011 at 21:53

Benoit

79.7k24 gold badges226 silver badges241 bronze badges

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

Comments

Conrad Frix · Accepted Answer · 2011-11-02 22:00:46Z

2

Take off VALUES before select statement. That should work.

INSERT INTO 
    rare_csshop.cscart_product_features_values
        (feature_id, product_id, value, lang_code)
    SELECT DISTINCT
    "10" As Feature, t1.product_id, CONCAT(t2.NHeigth, "\" H x ", t2.NWidth, "\" W x ", t2.NDepth, "\" D") As Dimensions, "EN" As Lang
FROM
    rare_csshop.cscart_product_descriptions AS t1, 
    rare_csshop.products AS t2
WHERE
    t1.product = t2.NName

I don't know why, but I came across this situation just recently. May be when we specify VALUES, it assumes only values not query results.

edited Nov 2, 2011 at 22:00

Conrad Frix

52.8k13 gold badges100 silver badges158 bronze badges

answered Nov 2, 2011 at 21:56

murali

2371 gold badge7 silver badges17 bronze badges

1 Comment

Conrad Frix Over a year ago

Welcome to Stackoverflow. Just wanted to let you know you can format your code by selecting it and either pressing Ctrl+K or the {} button. I took care of it for you already.

Collectives™ on Stack Overflow

SQL Syntax Error - INSERT INTO ... SELECT

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