MySQL Existance Syntax Error

Asked Aug 19 '16 at 18:14

Active Aug 19 '16 at 18:20

Viewed 55 times

I'm getting a MySQL syntax error for the following query:

IF NOT EXISTS (SELECT * FROM `guilds` WHERE `ID` = 123)
BEGIN
INSERT INTO guilds (`ID`, `Prefix`, `Join`, `Leave`) VALUES ('123', '//', '    Welcome!', 'Goodbye!');
END

I don't know what's causing this, could somebody help?

I've looked at other examples of this, and they seem to be identical to this one, with the exception that this one doesn't work.

edited Aug 19 '16 at 18:20

asked Aug 19 '16 at 18:14

Arraying

2

You can use flow statements like `IF` only in fuctions or procedures, or triggers.... – juergen d Aug 19 '16 at 18:15
`if` like that only works in sprocs. it does not work as an independent query statement. – Marc B Aug 19 '16 at 18:15
1

I see a missing semi-colon after at the end of the INSERT statement. – Derick Alangi Aug 19 '16 at 18:16
Why not use `INSERT IGNORE`? – tadman Aug 19 '16 at 18:17
@d3r1ck Added the missing ;. – Arraying Aug 19 '16 at 18:19
@Arraying, does that fix the problem? – Derick Alangi Aug 19 '16 at 18:23
@d3r1ckNope, it doesn't, unfortunately... If it helps, here is the error message – Arraying Aug 19 '16 at 18:23
@d3r1ck #1064 - 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 guilds WHERE `ID`=123) BEGIN INSERT INTO guilds (' at line 1 – Arraying Aug 19 '16 at 18:24
@Arraying you were given the answer in the 1st comment... – Shadow Aug 19 '16 at 18:28
Check this link: http://stackoverflow.com/questions/18696604/mysql-error-on-if-not-exists-where-not-exists, that will solve your problem. – Derick Alangi Aug 19 '16 at 18:32
@juergendthen then what would the query be in my situation: //check if a row exists where the id is 123, if no, create one, with prefix, join and leave being //, Welcome!, and Goodbye! ? – Arraying Aug 19 '16 at 18:33
@Arraying check the 4th comment from the top – Shadow Aug 19 '16 at 18:52

MySQL Existance Syntax Error

0 Answers0