sql syntax error from my query

Question

I'm recently developing database api using java, vertx, gradle and mysql. I think I made a correct query but it shows me an error. Anybody knows the problem? Thanks in advance.

Query :

INSERT INTO USER VALUES('[email protected]', 'test', 'password')
WHERE NOT EXISTS (SELECT * FROM USER WHERE email='[email protected]')

Error :

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'IF NOT EXISTS (SELECT * FROM USER WHERE email='[email protected]')' at line 1

Possible duplicate of MySQL: Insert record if not exists in table — dheiberg
– dheiberg, Commented Aug 8, 2016 at 8:37

erolkaya84 · Accepted Answer · 2016-08-08 08:36:27Z

2

I believe you should mention column names after INSERT INTO USER .

Something like this;

INSERT INTO USER (email, username, password)
VALUES('[email protected]', 'test', 'password') 
WHERE NOT EXISTS 
(SELECT * FROM USER WHERE email='[email protected]')

answered Aug 8, 2016 at 8:36

erolkaya84

1,85922 silver badges29 bronze badges

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

1 Comment

James Lee Over a year ago

It's been a long time to use sql so I forgot alot :( Thank you so much for reminding me!!

Blank · Accepted Answer · 2016-08-08 08:39:25Z

0

I think you should do it like this:

INSERT INTO USER
SELECT '[email protected]', 'test', 'password'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM USER WHERE email='[email protected]')

answered Aug 8, 2016 at 8:39

Blank

12.4k1 gold badge16 silver badges34 bronze badges

Collectives™ on Stack Overflow

sql syntax error from my query

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related