I am getting Syntax error in sql (insert)

Question

So, I am trying to add a data if a value in field does not exist. I am keep getting syntax error and not sure where I am getting it wrong.

INSERT INTO COMPANY_TABLE(company_name, company_phone, company_url)
VALUES ('test','010-4843-0000','www.company.com')
WHERE NOT EXISTS (SELECT * FROM COMPANY_TABLE WHERE company_name = 'test');

This is my code. I am using H2 database

What is the error message? (append to the question) ... also, add a tag for the DB vendor (MySQL, sqlite, etc) that you use. — Paul T.
– Paul T., Commented Nov 12, 2022 at 20:06

Stu · Accepted Answer · 2022-11-12 20:07:36Z

1

You're trying to combine a values table constructor with syntax of a select query

You can insert into a table using select:

INSERT INTO COMPANY_TABLE(company_name, company_phone, company_url)
SELECT 'test','010-4843-0000','www.company.com'
WHERE NOT EXISTS (SELECT * FROM COMPANY_TABLE WHERE company_name = 'test');

answered Nov 12, 2022 at 20:07

Stu

32.7k6 gold badges17 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

I am getting Syntax error in sql (insert)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related