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('test@test.co.kr', 'test', 'password')
WHERE NOT EXISTS (SELECT * FROM USER WHERE email='test@test.co.kr')

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='test@test.co.kr')' at line 1

Possible duplicate of [MySQL: Insert record if not exists in table](http://stackoverflow.com/questions/3164505/mysql-insert-record-if-not-exists-in-table) — dheiberg, Aug 08 '16 at 08:37

score 2 · Answer 1 · answered Aug 08 '16 at 08:36

2

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

Something like this;

INSERT INTO USER (email, username, password)
VALUES('test@test.co.kr', 'test', 'password') 
WHERE NOT EXISTS 
(SELECT * FROM USER WHERE email='test@test.co.kr')

answered Aug 08 '16 at 08:36

erolkaya84

1,454
18
24

It's been a long time to use sql so I forgot alot :( Thank you so much for reminding me!! – James Lee Aug 09 '16 at 05:40

score 0 · Accepted Answer · answered Aug 08 '16 at 08:39

0

I think you should do it like this:

INSERT INTO USER
SELECT 'test@test.co.kr', 'test', 'password'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM USER WHERE email='test@test.co.kr')

answered Aug 08 '16 at 08:39

Blank

11,958
1
11
30

sql syntax error from my query

2 Answers2