#1064 - You have an error in your SQL syntax... near if

Asked Nov 27 '17 at 15:00

Active Nov 27 '17 at 15:10

Viewed 206 times

My phpmyadmin is getting error with every IF statement. error is,

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF @@R

My code is like

UPDATE ...... WHERE .... AND `id`="123"
IF @@ROWCOUNT=0
INSERT INTO ......

how to fix this problem?

asked Nov 27 '17 at 15:00

Ramesh Kithsiri HettiArachchi

1,440
13
30

2

Your mixing SQL-server syntax with MySQL that's your problem.. MySQL doesn't support conditional SQL execution except within functions, procedures and triggers – Raymond Nijland Nov 27 '17 at 15:03
2

`@@ROWCOUNT` is for MS SQL – Ullas Nov 27 '17 at 15:03
1

`SELECT rows_affected();`, then do the "if" in your application language. – Rick James Nov 27 '17 at 17:15
1

Consider changing to `INSERT ... ON DUPLICATE KEY UPDATE ...` – Rick James Nov 27 '17 at 17:15

#1064 - You have an error in your SQL syntax... near if

0 Answers0