Can't find syntax error in simple sql command

Question

I have been looking at this for a while and i can't find the syntax error.

IF EXISTS (SELECT * FROM ElpasoTable WHERE elapsoCommand = 'shouldRunWlapon')
BEGIN
END

You cannot use `IF... BEGIN ... END` in a query. – Uueerdo Jun 21 '17 at 18:36 — Uueerdo, Jun 21 '17 at 18:36

score 0 · Answer 1 · answered Jun 21 '17 at 18:45

0

Try this for MySQL

IF EXISTS (SELECT * FROM ElpasoTable WHERE elapsoCommand = 'shouldRunWlapon') THEN
---- YOUR CODE HERE
END IF;

answered Jun 21 '17 at 18:45

Allen King

2,372
4
34
52

vijay · Answer 2 · 2017-06-21T19:04:41.450

0

Valid commands..

DROP TABLE IF EXISTS...,CREATE TABLE IF NOT EXISTS..

You cannot use IF EXISTS simply in a mysql command.

for your need you can try this instead

perfect solution for your case

usage of IF EXISTS

edited Jun 21 '17 at 19:04

answered Jun 21 '17 at 18:47

vijay

493
5
19

score 0 · Answer 3 · answered Jun 21 '17 at 19:13

Actually I don't know what output u want but here is the suggestion. We can't use directly if exists statement. We can use it after certain commands such as delete ,update ,Create etc. First if u want the desired output,remove if exists. So the query will be ( SELECT * FROM ElpasoTable WHERE elapsoCommand = 'shouldRunWlapon') If ur table has column named elapsocommand and value is shouldRunWlapon,,then the Elapsocommand table is displayed.

U can use some concepts between begin and end statements based on ur requirement. They are stored procedures , triggers, views etc

Can't find syntax error in simple sql command

3 Answers3